View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Hiding a whole sheet in a workbook

Hi L,

The code

Sheets("Sheet1").Visible = xlHidden

hides worksheet1, but it can be unhidden from Excel's format menu

The staement:

Sheets("Sheet1").Visible = xlVeryHidden

hides the sheet so that it can only br unhidden from the VBE or with code.

Bear in mind that Excel requires at least one sheet to be visible.


---
Regards,
Norman



"L.White" wrote in message
...
Hello,

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.

LWhite