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?