Read-only access by SHEET (not workbook). Is it possible?

E

emcphee

Hi -
I have a workbook with about 15 separate sheets, for 15 PMs. Is there a way
that I can give read-only access to the workbook with the EXCEPTION of the 1
sheet that belongs to a specific person?

Any help would be greatly appreciated.
 
E

emcphee

Thanks Anne!

I do have Excel 2003, and I did set up password protection in each sheet.
However, once the individual unlocks the sheet, it remains open unless they
"re-lock" it. Is there a way that I can make the sheet automatically lock
again once it's exited?

Thanks in advance,

Eunice
 
Top