is there a code that makes the label of the worksheet invisible? But does the worksheet remain visible?
With the label I mean indicated in the photo with red arrowNaamloos.jpg
is there a code that makes the label of the worksheet invisible? But does the worksheet remain visible?
With the label I mean indicated in the photo with red arrowNaamloos.jpg
Paste this into the ThisWorkbook Module of the workbook:
Please Login or Register to view this content.
Hi Toby,
I think you are looking for the File > Options > Advanced > Display Options for this workbook > Show Sheet Tabs
Uncheck this box and see if that is what you are trying to do.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
it is a setting that you can switch between true and false. you can find it in options > advanced > Display options for this workbook. uncheck "Sheet tabs"
This code below is a toggleCode that will turn on or turn off sheettabs. if you link that code to a shortcutkey you can switch it on and off with that same shortcutkey
If you want to make it part of a larger code you can also add the linePlease Login or Register to view this content.
to turn them off andPlease Login or Register to view this content.
to turn them back onPlease Login or Register to view this content.
thanks for all the reply's, its done with de option in the menu. thanks!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks