select a1 on all sheets

[Piers Clinton-Tarestad]

Is there a simple macro you can write so for every sheet in the current book
a1 is selected i know you can change the workbook so on the event
sheetselect a1 is selected but I only want to select a1 before i close the
file so when the next person opens it everything is set up to view in the
right place

any help gratefully received!
piers

 

[Harald Staff]

Hi Piers

Sure:

Sub test()
Sheets.Select
Range("A1").Select
Sheets(1).Select 'or whatever
End Sub

It flashes a tiny bit. Set screenupdating to False if it bothers you.