Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unable to see or show sheet 1 in excel
It may not have a sheet 1 or the sheet may be very hidden in which case it
can only be made viewable with vba. Try this Sub test() x = Worksheets.Count MsgBox (x) Worksheets("Sheet1").Visible = True The message box will tell you how many sheets you have in the workbook and if it is very hidden it will be unhidden. Mike End Sub "blank flange" wrote: On opening a work book sheet 1 is not shown. It starts on sheet 2. The goback pointer does not operate. I tried Format/Sheet/ but unhide is greyed out |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to see or show sheet 1 in excel | New Users to Excel | |||
unable to view photos in excel sheet | Excel Worksheet Functions | |||
Excel: have add'l rows entered in sheet 1 always show up in sheet | Excel Worksheet Functions | |||
Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel |