where excel opens a workbook

  • Thread starter Thread starter mikegospo
  • Start date Start date
M

mikegospo

I have some documentation in an excel workbook. Each worksheet contain
information. I have several users who can edit the information. Whe
they save the file it opens in the condition they had it in when the
saved. Is there a way to force all sheets to location A1 and open to
certain worksheet each time
 
Hi
only with a macro. That is inserting some code in the workbook_open
event. e.g. to go always to sheet one insert the following code in your
workbook module

sub workbook_open()
me.worksheets("sheet1").activate
end sub
 
this should do it. Put in workbook_open event in ThisWorkbook module

For Each ws In Worksheets
ws.Activate
Application.Goto Range("a1")
Next
Sheets(1).Select
 
Back
Top