Password protecting a worksheet
Hi all,
I am trying to find out whether it is possible to password protect a worksheet within a workbook. I have 3 worksheets in my workbook and want to allow the user access to 2 of them. The 3rd one I dont want to allow the user any access (not even to view the contents) unless they have a password. Is this possible? Many thanks |
Hide your desired sheet, Protect the workbook with a password (don't lose the password). Save the file, close the file, reopen the file. You now need to unprotect the workbook to be able to unhide the sheet. HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=473540 |
|
All times are GMT +1. The time now is 03:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com