Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Protection of a worksheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
gregchilton@bigpond.com - 23 Jan 2006 23:04 GMT
Hi

I have two questions.

The first one: is it possible to protect certain parts and not the
whole worksheet and,
The second one: is it possible to prevent a person changing the name of
a worksheet.

Thanks

Greg
Pete_UK - 23 Jan 2006 23:43 GMT
The answer to both questions is yes.

By default, individual cells are set to "Locked", but this only comes
into force when the worksheet is actually protected. So, you need to
unlock the cells that you want to allow users to change, and to do this
you need to highlight them, then go to Format | Cells | Protection
(tab) and unclick Locked. Then you need to select Tools | Protection |
Protect Sheet and you have the option of password-protection (you will
have to enter it twice, but choose something memorable).

If users try to edit a locked cell they will be told that they can't,
but they will be able to edit an unlocked cell. They can't change
formats or column widths, and will not be able to change the name of
the sheet.

Hope this helps.

Pete
Peo Sjoblom - 24 Jan 2006 02:47 GMT
And if they can go online and use a search engine they can find a password
crack, anyone who uses Excel to store sensitive material is beyond naive

Signature

Regards,

Peo Sjoblom

Portland, Oregon

> The answer to both questions is yes.
>
[quoted text clipped - 14 lines]
>
> Pete
Gord Dibben - 24 Jan 2006 05:03 GMT
>and will not be able to change the name of
>the sheet.

Sheet protection alone will not prevent changing the sheet name.

Workbook Protection must be enabled to prevent sheet name changes.

Gord Dibben  MS Excel MVP

>The answer to both questions is yes.
>
[quoted text clipped - 14 lines]
>
>Pete
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.