Sheet Protection -- Content vs. FORMATTING

J

jayceejay

I know that in Excel 2003, it is possible to protect a worksheet making it
possible for a user to change FORMATTING but NOT CONTENT. Is this a new
feature to Excel, Starting with 2003? I just tried to do the same thing in
Excel 2000 and I don't even see the option . Is it "ALL OR NOTHING" in 2000?
 
K

Ken Wright

Intro'd in Excel 2002

2000 is all or nothing.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------

jayceejay said:
I know that in Excel 2003, it is possible to protect a worksheet making it
possible for a user to change FORMATTING but NOT CONTENT. Is this a new
feature to Excel, Starting with 2003? I just tried to do the same thing in
Excel 2000 and I don't even see the option . Is it "ALL OR NOTHING" in
Click to expand...
2000?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
Excel does not accept text format! 0
Making "Change Highlighting" feature darker 1
Formatting Rich Text Content Controls in a protected document 2
Sheet Protection 2
Using Styles In An Outline 0
New computer, how do i move outlook 365 ENTIRELY? 0
Protect workbook for Windows option is grayed out in Excel 2013 3

Top