select a1 on all sheets

  • Thread starter Thread starter Piers Clinton-Tarestad
  • Start date Start date
P

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
 
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.
 
Back
Top