I don't know if this is possible but I'd like to publish a Workbook that has several tabs. The first tab has links to the other tabs but I want to hide these so they don't show when I publish the HTML. I still want the links to work and navigate to the hidden tabs but I don't want the tabs themselves to show on the 'home Excel' html page.
migrated from stackoverflow.com May 5 '11 at 16:49
This question came from our site for professional and enthusiast programmers.
You can use this VBA - it will make a hidden macro "hide" that will hide the "sheet2" and can only be unhidden by changing the value of the hidden macro, or executing a different macro that sets the