Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SHEETS
This may be really simple, but is there a way to hide a
sheet in a workbook that is used for bits of information the user isn't concerned with but the VBA code is. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SHEETS
Jonny,
I assume that Format/Sheet/Hide isn't secure enough for what you want to do?? Manually, you can select the sheet from the VBA editor and change it's Visible property to VeryHidden. Via code: worksheets("yoursheetname").visible = xlveryhidden To make it visible again, change the Visible property manuall as above or worksheets("yoursheetname").visible = True The VeryHidden property insures that the sheet won't show up on the Format/Sheet/UnHide menu. John "Jonny" wrote in message ... This may be really simple, but is there a way to hide a sheet in a workbook that is used for bits of information the user isn't concerned with but the VBA code is. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SHEETS
Jonny wrote:
This may be really simple, but is there a way to hide a sheet in a workbook that is used for bits of information the user isn't concerned with but the VBA code is. You can hide a sheet using Format/Sheet/Hide (I guess, I use Spanish Excel). At least this is in Excel 2002. To find out the VBA code to do this, just record your steps while doing it. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy cell info to other sheets, other sheets dont contain all row. | Excel Worksheet Functions | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets | Excel Programming |