View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default Hiding a whole sheet in a workbook

"L.White" wrote in message
...
Is it possible to hide an entire sheet in a workbook? I have sheets that
have information brought in through SQL queries. I just don't want my
users to be able to see them. The less there is for them to click on the
better.


Choose Format/Sheet/Hide from the Excel menu, or

Worksheets("YourSheet").Visible = xlSheetHidden

if you're trying to do this from VBA.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm