Post by talk2santosh on Feb 22, 2004 3:57:56 GMT -5
Have you come across situations when you feel that users should not be able to see particular sheets of your excel files?
If yes, try this:
You can use Excel's Format, Sheet, Hide to hide an entire worksheet. But unless you password-protect the workbook structure, anyone can select Format, Sheet, Unhide to see the hidden sheet.
* Press Alt-F11 to display the Visual Basic Editor.
* In the Project window, double-click Microsoft Excel Objects and select the sheet to hide.
* Press F4 to display the Property box
* Set the sheet's Visible property to xlSheetVeryHidden.
* To unhide the sheet, repeat these step, but set the Visible property to xlSheetVisible.
Article has been taken from www.techjaal.com
If yes, try this:
You can use Excel's Format, Sheet, Hide to hide an entire worksheet. But unless you password-protect the workbook structure, anyone can select Format, Sheet, Unhide to see the hidden sheet.
* Press Alt-F11 to display the Visual Basic Editor.
* In the Project window, double-click Microsoft Excel Objects and select the sheet to hide.
* Press F4 to display the Property box
* Set the sheet's Visible property to xlSheetVeryHidden.
* To unhide the sheet, repeat these step, but set the Visible property to xlSheetVisible.
Article has been taken from www.techjaal.com