ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Locking a sheet?? (https://www.excelbanter.com/excel-discussion-misc-queries/63978-locking-sheet.html)

mcr1

Locking a sheet??
 

Is there anyway to lock a sheet so it cannot be selected at all? I
will/can even accept hiding the sheet, but would prefer to have it just
locked so it cannot be selected. As always, thanks in advance.

mcr1


--
mcr1
------------------------------------------------------------------------
mcr1's Profile: http://www.excelforum.com/member.php...o&userid=15496
View this thread: http://www.excelforum.com/showthread...hreadid=499448


cbh35711

Locking a sheet??
 

Just go up to tools-protection-protect sheet. Then protect it with
whatever password. Then after that you can go up to
Format-Sheet-Hide Then select your sheet.
That was for Excel 2003

Hope that helps,

Chris


--
cbh35711
------------------------------------------------------------------------
cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276
View this thread: http://www.excelforum.com/showthread...hreadid=499448



All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com