Formatting Protection

[Luis939]

Hi, Im trying to mess around with the protection properties of Excel 2000, and I cant seem to find a way to protect formatting in a spreadsheet. The closest I got was to unlock everything and then protect the worksheet, which still allowed me to edit text and keep my formatting. But it didn't allow me to insert rows or anything like that. Is there anyway to protect just the formatting cells, such as font color, size, etc. Thanks!

 

[bronc]

XP has selective protection - Tools,... Protect sheet. i'm not sure if 2000 has it.

 

[Chattin]

As bronc sais XP has this feature but (AFAIK) it's not available in xl2k

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[bronc]

here's a bit of code from the macro recorder in XP - don't know if it applies to 2000:

ActiveSheet.Protect AllowFiltering:=True