View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
exalan exalan is offline
external usenet poster
 
Posts: 28
Default Unable to password-protect "VeryHidden" worksheet

Hello

I'm using Excel 2007. In VBE I tried to password-protect a "VeryHidden"
worksheet by going to VBAProject Properties, Protection, check the box on
"Lock project for viewing" and set the password in the boxes as provided.

However, each time I re-open the file (after saving and closing the file),
the worksheet was not protected. When I check the VBAProject Properties, the
check box of "Lock project for viewing" and the "Password to view project
properties" are all back to its original state of unchecked/empty.

Please advise what steps I've missed to do the password protection.

Many thanks
--
exalan