MrExcel Publishing
Your One Stop for Excel Tips & Solutions

hidden worksheet..have problem on this..


Posted by newby on March 20, 2000 1:26 AM

is there any trick to hide worksheet.
what i means if u protect your workbook with p/word..
people still can open your hidden w/sheet..any suggestions..
thanks..bye n regards


Posted by AB on March 21, 2000 5:56 AM

If you press ALT-F11 it will take you to the VB editor. Select the sheet you want to hide in the project explorer. Set the VISIBLE property of the sheet to xlVeryHidden. As far as the users are concerned, the sheet doesn't exist.