 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2006protection - hiding worksheets
hi, I want to be able to open a workbook and be able to see all the worksheets within it, but I want all other users to open the worksook and see only 3 of the worksheets. Is there some way of protecting the workbook to make this happen? thanks for your help! You could use a simple macro to auto hide the sheets ie Sub auto_open() Sheets("Sheet1").Visible = False End Sub Matt  SignatureMallycat Hi > You could use a simple macro to auto hide the sheets ie > > Sub auto_open() > Sheets("Sheet1").Visible = False > End Sub But anyone holding down Shift key when opening workbook, can bypass this. Arvi Laanemets but if I do this, it means when I open the workbook, I will not be able to see the sheets either? > Hi > [quoted text clipped - 7 lines] > > Arvi Laanemets It doesn't help that this message is in it's own thread without the original question, but I'm GUESSING you want something like a sheet being hidden unless you are the owner - I would set the sheets to VERYHIDDEN (which means no one can get to them) and then assign a macro EITHER to a keystroke to unhide them OR to run on open to (perhaps) check for the current user and IF valid, unhide them. > but if I do this, it means when I open the workbook, I will not be able to > see the sheets either? [quoted text clipped - 10 lines] > > > > Arvi Laanemets Are yourself and the other users on a Windows network? If so, you can probably easily achieve your goal. Let me know if you are on a network and I will send you the required code, which should work (but I don't guarantee it!) Regards Ian SignatureWork performed in the spirit of service is worship...Baha''i Writings > hi, > [quoted text clipped - 4 lines] > > thanks for your help! |
Reply to this Message |
 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
|
©2009 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.