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

Hi Piers

Su

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.
--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Piers Clinton-Tarestad" wrote in message
...
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