Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
add comment

migrated from stackoverflow.com May 5 '11 at 16:49

This question came from our site for professional and enthusiast programmers.

1 Answer

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 visible property to false or true

Private Sub Hide()

Sheets("sheet2").Visible = xlVeryHidden

End Sub
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.