View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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