Hi, I have an Excel 2010 file with many sheets all linked using hyperlinks. I use the xlsm file for my editing and a web-saved file for viewing by others. How can I show my web file without it displaying the sheet tabs. I hide these tabs before saving as a web page but when I view the web page the tabs are visible. I know everything is possible with Excel so would be grateful if someone could point me in the right direction.
Just to let you know. Everything is not possible in Excel. I have started 3 threads and gotten lots of help, but still haven't found a way to do what I want.
Try making the sheet very hidden.
Select the worksheet
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
In the properties Pane on the left locate Visible & change to xlSheetVeryHidden
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
thanks, that seemed to work. However, I need to edit the normal excel file occasionally so how do I find the sheets after having 'very hidden' them? cheers..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks