Monday, September 19, 2011

Excell : Hide sheet

Do you have "secret" sheet to be hidden in Excell?
If you click right on the sheet and select "Hide" anyone can "unhide" it to see the "sheet"

I know, and your sheet will be invisible in "unhide" area.
The step:
For example you want "sheet1" is invisible.
- Go to VBA editor by "ALT+F11"
- Select "sheet1" in" project" sheet
- Select "2xlSheetVeryHidden" in Properties area.

Close VBA editor, and you can and you will find that "sheet1" is not visible, even in "unhide" area.

Cheers.

No comments:

Post a Comment