Skip to Content
0
Former Member
Mar 25, 2009 at 02:15 AM

Password protection doesn't work after Refresh

35 Views

Hi experts,

There are 2 portions in my input schedule, i need to password protect portion A, and let users make entries in portion B. so what i did was i highlighted all the cells in portion B, right click to get "format cells", and then clicked on the "protection" tab, i then unclicked "locked". then i clicked on "set workbook options" and clicked on "set worksheet password", i put in a password. then i saved the template.

When i reopened the template, everything works fine, i.e. any attempt to enter data in portion A will prompt an error asking me to unprotect the worksheet, while i can enter data in portion B. However when i refreshed the worksheet, a step i consider to be a best practice, what happens is that both portion A and B are now password protected.

Any suggestions, experts?

Thanks in advance.

Cheers