|
Posted to microsoft.public.excel.misc
|
|
|
force first page view
"amanda" wrote:
Hi Mike,
I have done that, but if I save on any sheet other than the one named it
does not work. Have I done something wrong?
Thanks
Amanda
"Mike H" wrote:
Amanda,
Alt+F11 to open VB editor. Double click 'ThisWorkbook' and paste the code
below in.
Change the name to the sheet you want
Private Sub Workbook_Open()
Application.Goto Sheets("Particular sheet").Range("A1")
End Sub
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"amanda" wrote:
Hi,
I have an excel spreadsheet with lots of different sheets. I want the force
a specific sheet to be visible whenever the file is opened - irrelevant of
how the file was saved. So, the specific sheet is the first thing that
anyone who opens the file sees.
Is that possible?
Thank you
Amanda
|