Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default password protect a single sheet

If you hide a sheet then protect the workbook, Format/Sheet/Unhide will be
disabled until you unprotect the workbook!

Stefi

Brian ezt *rta:

i tried this and i see nothing changed. toolsprotectionprotect workbooki
enterd password thinking it would ask me what i wanted to do but it did
nothing. any other suggestions would be appreciated.
thanks for the fast reply Stefi!
--
Brian


"Stefi" wrote:

You can do that by protecting the workbook: Tools/Protection/Protect workbook

Regards,
Stefi



Brian ezt *rta:

hello all,
i was wondering if there is a way to password protect a worksheet. i have
many workbooks with multiple worksheets that people have access to. there are
sheets that people do not need to see. i know i can hide these sheets, but i
would rather have a password to open them so that if there are people who
need to open them they can by entering a password.
thank you for your time and have a great day!
--
Thank You in advance, Brian

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
password protect a single sheet stumac Excel Discussion (Misc queries) 0 March 28th 07 12:12 AM
Password Protect a Sheet Lynn Excel Discussion (Misc queries) 1 October 27th 06 03:41 PM
How do I password protect hidden sheet? Mascot Excel Discussion (Misc queries) 1 October 5th 06 03:52 PM
Password protect a sheet without Macros Cappa Excel Discussion (Misc queries) 3 May 27th 06 01:49 AM
How do I password protect a single tab in a worksheet in excel ? Fritz Excel Discussion (Misc queries) 4 March 6th 06 03:30 PM


All times are GMT +1. The time now is 11:27 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"