Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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

Reply
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
Unable to see or show sheet 1 in excel JLatham New Users to Excel 0 February 21st 07 01:51 PM
unable to view photos in excel sheet sach Excel Worksheet Functions 1 December 18th 06 11:11 AM
Excel: have add'l rows entered in sheet 1 always show up in sheet Sooz in Grants Pass Excel Worksheet Functions 0 September 18th 06 01:33 AM
Unable to open excel file and when view the file size show as 1 KB Kamal Siva Excel Discussion (Misc queries) 1 March 7th 06 03:23 AM
Unable to open excel sheet in Protected mode from VB 6.0 ourspt Setting up and Configuration of Excel 0 January 26th 05 11:07 AM


All times are GMT +1. The time now is 05:11 PM.

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

About Us

"It's about Microsoft Excel"