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