ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Sheet Protection -- Content vs. FORMATTING (https://www.excelbanter.com/new-users-excel/19697-sheet-protection-content-vs-formatting.html)

jayceejay

Sheet Protection -- Content vs. FORMATTING
 
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?

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" wrote in message
...
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?




All times are GMT +1. The time now is 03:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com