View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Michael M Michael M is offline
external usenet poster
 
Posts: 118
Default When I open Excel I want it to open on Sheet 1

Hi George
You can add the line
Application.DisplayAlerts=False

to disable the macro message from appearing

Regards
Michael M

"George Nicholson" wrote:

Add this to the "ThisWorkbook" module:
(Alt-F11 to open VB editor expand Project & ExcelObjects dblClick
ThisWorkbook entry copy & paste in code window. Save.)

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Activate
End Sub

Change "Sheet1" to the name of your cover page as the User sees it.

Note: you now have code in your workbook. Users can choose not to enable
macros, so it isn't foolproof, but I'm not aware of any way to do what you
want that wouldn't envolve coding.

HTH,

"traveye" wrote in message
...
OK, I have an excel file that many employees use and save thier
information
in. If an employees enters info into sheet 4 and then saves it, when the
next employee opens the same file it will open directly to sheet 4. This
file has a "cover page" which is sheet 1. I always want excel to open up
to
sheet 1 no matter what sheet it was previously saved in. Is this possible?