PDA

View Full Version : Solved: How to Hide the Sheets Bar in a excel File?



Esmatullah
01-03-2013, 10:08 PM
Hi dears!
I need a code, VBA or other ways to hide the sheets name bar for my file.

GTO
01-04-2013, 12:51 AM
What code have you tried writing, or at least, recording?

jignesh142
01-04-2013, 01:40 AM
Private Sub CommandButton1_Click()
ActiveWindow.DisplayWorkbookTabs = false


End Sub

Esmatullah
01-04-2013, 11:11 PM
Thanks Dear jignesh142 i received your answer.