Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help! Lost sheets by using View Code on worksheet tab
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help! Lost sheets by using View Code on worksheet tab
Hi Michelle
Try FormatSheetUnhide You should see a list of the hidden sheets. Just select each one to be unhidden. -- Regards Roger Govier "Michele" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help! Lost sheets by using View Code on worksheet tab
FormatSheetUnhide.
If you actually used 2-xlVeryHidden you will have to unhide using code or hit ALT + F11 and CTRL + r Expand your workbook/project and from the list of sheets select each sheet that was hidden and ViewProperties and change to 1-xlSheetVisible Gord Dibben MS Excel MVP On Tue, 28 Nov 2006 12:55:02 -0800, Michele wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help! Lost sheets by using View Code on worksheet tab
Return the the previous copy of the file.
You did make a copy before you played with the newly found features didn't you :) Otherwise use the tips the others posted. But next time, make a copy of the file and try it on the copy Steve On Tue, 28 Nov 2006 20:55:02 -0000, Michele wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |