Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide sheet in workbook
How would I hide a worksheet in a workbook if I don't want people to see if I sent the workbook to them. I still want this sheet though because it affects the main sheet. Thanks -- rbrickl ------------------------------------------------------------------------ rbrickl's Profile: http://www.excelforum.com/member.php...o&userid=35910 View this thread: http://www.excelforum.com/showthread...hreadid=565339 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide sheet in workbook
'Format'....'sheet'....'hide'
"rbrickl" wrote: How would I hide a worksheet in a workbook if I don't want people to see if I sent the workbook to them. I still want this sheet though because it affects the main sheet. Thanks -- rbrickl ------------------------------------------------------------------------ rbrickl's Profile: http://www.excelforum.com/member.php...o&userid=35910 View this thread: http://www.excelforum.com/showthread...hreadid=565339 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide sheet in workbook
You can hide a sheet and password protect the workbook under
ToolsProtectionProtect Book. Just be aware that Excel internal passwords are very easy to crack. You could through VB Editor make the sheet xlveryhidden then put password protection on the VBA project. This password is a little harder to crack. In general........if you don't want someone to see it, don't include it in the workbook. Gord Dibben MS Excel MVP On Wed, 26 Jul 2006 16:26:52 -0400, rbrickl wrote: How would I hide a worksheet in a workbook if I don't want people to see if I sent the workbook to them. I still want this sheet though because it affects the main sheet. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
Opening workbook at sheet required. | New Users to Excel | |||
Aways open workbook on sheet 1 ??? | Excel Discussion (Misc queries) | |||
Use Sheet CodeNames to Select Sheet in Different Workbook | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |