If you want to hide the Sheet Tab (as shown below) you can do that using Excel Options
Uncheck the Show sheet tabs checkbox from Advanced Tab of Options Menu
You can do the same through Excel VBA
ActiveWindow.DisplayWorkbookTabs = False
Welcome to VBA Tips & Tricks. All VBA related information will be posted on this blog. Of late, VBA has been disregarded by many software professionals for .Net, c# and other technologies. This blog will also post articles related to them too Happy reading
ActiveWindow.DisplayWorkbookTabs = False