Changing font on a protected sheet

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

I meant to say is that in the 2000 version. I went to
TOOLS>PROTECT>PROTECT SHEET and did not see a check box to
allow formatting.

Any ideas??? Thanks...


yep.
 
I wondered why you wouldn't have just looked if you really meant xl2002 (XP).

But this granular level of protection was added in excel 2002 (XP).

Maybe you could provide a macro that unprotects the sheet, does the formatting
and the reprotects the sheet.
 
Back
Top