Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sherree
 
Posts: n/a
Default Protect Format OF Worksheet

How do I allow data entry on a new excel worksheet and protect the format
from being changed or deleted?
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Which version of Excel are you running?

2002 and 2003 allow much more versatilty with protected sheets.


Gord Dibben Excel MVP

On Wed, 15 Jun 2005 13:34:07 -0700, "Sherree"
wrote:

How do I allow data entry on a new excel worksheet and protect the format
from being changed or deleted?


  #3   Report Post  
Sherree
 
Posts: n/a
Default

Iam using Excel 2003.

"Gord Dibben" wrote:

Which version of Excel are you running?

2002 and 2003 allow much more versatilty with protected sheets.


Gord Dibben Excel MVP

On Wed, 15 Jun 2005 13:34:07 -0700, "Sherree"
wrote:

How do I allow data entry on a new excel worksheet and protect the format
from being changed or deleted?



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
Protect Worksheet but allow to insert or delete rows Bob L Hilliard Excel Discussion (Misc queries) 2 June 9th 05 02:08 PM
How to save worksheet in .cvs format? Carlannie Excel Discussion (Misc queries) 1 April 21st 05 07:19 PM
protect a protected worksheet darshan Excel Discussion (Misc queries) 3 February 18th 05 01:12 AM
Refrencing another cell in a worksheet that "could" exist KimberlyC Excel Worksheet Functions 1 February 7th 05 07:09 PM
How do I change format of all comments in worksheet? Clare Castle Excel Discussion (Misc queries) 1 January 19th 05 03:54 PM


All times are GMT +1. The time now is 10:45 PM.

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"