LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 90
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy and use vba code Giz Excel Discussion (Misc queries) 9 November 22nd 06 09:57 PM
Best Approach to Worksheet Synchronization mjones Excel Discussion (Misc queries) 7 November 8th 06 11:39 AM
Change case...help please Terry Excel Worksheet Functions 14 October 2nd 05 12:29 PM
Formating Sheets made in Code Jenn Excel Discussion (Misc queries) 1 August 22nd 05 05:19 PM
Macro to simply bring up the Find dialogue box?? marika1981 Excel Discussion (Misc queries) 14 January 14th 05 10:47 PM


All times are GMT +1. The time now is 07:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"