LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Protecting a worksheet within a workbook

Angela

Hide the sheet with formatsheethide then ToolsProtectionProtect Workbook
with a password.

Note: Excel's internal(worksheet and workbook) protection is not very secure and
many password crackers abound on the Internet.


Gord Dibben MS Excel MVP

On Mon, 11 Dec 2006 10:30:00 -0800, Angela
wrote:

I have a workbook that has 6 worksheets in it. The last worksheet is an
ordering form and I do not care for anyone to view it, but I definitely do
not want anyone to change the formuals or information inside this one
worksheet.

How can I protect this one worksheet from anyone going in and changing
information?

Thank you,
Angela




 
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
Copy Worksheet from one Workbook to another Workbook Autumn Dreams Excel Discussion (Misc queries) 5 September 12th 08 10:55 PM
Protecting all worksheets of a workbook neeraj Excel Discussion (Misc queries) 14 May 30th 06 09:46 PM
Copying A Worksheet From Each Open Workbook to an new Workbook carl Excel Worksheet Functions 1 January 3rd 06 05:37 PM
copy worksheet to another workbook jtaiariol Excel Discussion (Misc queries) 5 January 1st 06 06:32 PM


All times are GMT +1. The time now is 07:52 AM.

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

About Us

"It's about Microsoft Excel"