Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default can hidden sheets be prevented from opening without a password?

I want to prevent a worksheet being viewed by other users of the workbook.
Can this be done by, say, password protection, as can be done in Word?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default can hidden sheets be prevented from opening without a password?

Yes.
Hide the sheet, then Tools/ Protection/ Workbook
--
David Biddulph

"unclepablo54" wrote in message
...
I want to prevent a worksheet being viewed by other users of the workbook.
Can this be done by, say, password protection, as can be done in Word?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default can hidden sheets be prevented from opening without a password?

Hi unclepablo54,

It certainly can.

In Excel 2007, you would first hide the sheets that you want to remain
hidden. Then click "Protect Workbook" from the "Review" section of the
ribbon. You click on "Protect the Structure and Windows" and leave "Windows"
ticked. Enter your password and your workbook is protected.

Users cannot unhide the sheets without the password.

I hope this helps.

Cheers,
Nick


--
Nicholas Perkins
Excel Analyst, Designer and Programmer
http://www.nicholasperkins.com/
is bad.com
(Please remove the spamisbad)



"unclepablo54" wrote:

I want to prevent a worksheet being viewed by other users of the workbook.
Can this be done by, say, password protection, as can be done in Word?

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
opening a group but keep hidden rows hidden MWL Excel Discussion (Misc queries) 0 February 17th 09 03:16 PM
Password protect a hidden tab Dominic Excel Discussion (Misc queries) 2 March 23rd 06 09:23 PM
Excel 2003 spreadsheet saving prevented by violation error USAOz Excel Discussion (Misc queries) 2 March 12th 06 02:50 AM
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. Daniel Excel Worksheet Functions 0 June 23rd 05 11:56 PM
how can I password hidden columns David Allen New Users to Excel 1 March 19th 05 04:47 PM


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