Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a multi-sheet worksheet for tracking vacation and sick time for our
team. I copied it to the 2007 year name and was updating it for the coming year. There are sheets for each month, a Totals sheet, and another sheet which holds data for calculations, but I don't want anyone to access/change the data on the calculations sheet. I 'found' a new functionality; on the sheet tab, right click, select View Code, and it brings up Microsoft Visual Basic windows. One of those windows has "Properties - Sheet "(sheetname) and the last of those properties is "Visable". I selected "0 - xlSheetHidden" thinking it would effectively 'hide' that one worksheet. That sheet and two others disapeared from my tabs list. And I can't find them to get them back. Any help? -- Michele B. Ohio |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy and use vba code | Excel Discussion (Misc queries) | |||
Best Approach to Worksheet Synchronization | Excel Discussion (Misc queries) | |||
Change case...help please | Excel Worksheet Functions | |||
Formating Sheets made in Code | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) |