Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
Index/Contents Sheet | Excel Discussion (Misc queries) | |||
In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel |