Hello,
I'm working in an excelfile that seems to have a very hidden sheets bar. There are a few very hidden sheets that I have managed to unhide. The problem however still remains, I wish to be able to click on the sheet names at the bottom of the screen to navigate and see the names more easily. The show sheets tab is of course checked...
Looking for tips on how to get the actual sheet bar back...
Hii,
try this
Press
Alt+11 => see at top Insert .. Module and paste following code
Please Login or Register to view this content.
press Alt+F8 and Run the Macro
Don`t care, take care...
Regards,
Mangesh
Thank you for the tip, it did however unfortunately not work for me.
Nothing happens when i run the Macro.
More tips are welcome
I am surprised how sheets are still hidden??
please attach file...
Hi, Here2learn,
please try this command to make the tabs of the sheets visible:
As this command will be acvtive for the whole workbook you would only need to run it once in order to make all tabs visible.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks