Protecting individual cells in Excel 97 2

[hopper13]

Is there a way to protect single, or groups of cells from being edited. The goal is to let people be able to change some cells on a sheet but allow only managers with a common L/P to change others on the same sheet.

 

[DaleWatson123321]

Hi hopper13,

Quick response to get you started...

What about creating a Button (perhaps entitled "Manager Access", for example) which managers could "click", and be prompted for the password which would then unprotect the sheet.

Then, you would need to include code to use when the file is saved, to automatically "re-set" the password protection.

Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca