Changing font on a protected sheet

[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.

 

[Dave Peterson]

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.