Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jayceejay
 
Posts: n/a
Default 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?
  #2   Report Post  
Ken Wright
 
Posts: n/a
Default

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sheet protection and "Group and Outline" OkieViking Excel Discussion (Misc queries) 9 May 22nd 07 05:17 PM
Copying multiple sheets from one book 2 another and undertake spec Pank Mehta Excel Discussion (Misc queries) 14 March 16th 05 04:41 PM
Filter Switches vs Sheet Protection? Ken Excel Discussion (Misc queries) 3 February 23rd 05 09:38 PM
Cell Colors and Sheet Protection cincode5 Excel Discussion (Misc queries) 1 December 3rd 04 10:39 PM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"