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
|