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
|