Hi
I have sheets named mon,tues,wed etc & I when I click on any of the sheets, I would like to go to the same cell on the sheet activated as the sheet I just left.
So, if I'm on A7 on mon sheet, when i click fri sheet, a7 be the active cell on that sheet.
Or, if on thurs sheet on B42 & click on tues, again be on the previous address, B42, on the tues sheet.
I've tried with Worksheet_Activate & Deactivate & storing the previous address globally from Worksheet_SelectionChange & then going to that range, but with no success.
I also looked at Worksheet_Activate, but again I had no luck as I don't know how to store the previous activecell, or pass that info on & then select it on the new sheet.
I thought it would be quite easy (& it may well be), but it isn't easy enough for me !!
thanks for any pointers
I have sheets named mon,tues,wed etc & I when I click on any of the sheets, I would like to go to the same cell on the sheet activated as the sheet I just left.
So, if I'm on A7 on mon sheet, when i click fri sheet, a7 be the active cell on that sheet.
Or, if on thurs sheet on B42 & click on tues, again be on the previous address, B42, on the tues sheet.
I've tried with Worksheet_Activate & Deactivate & storing the previous address globally from Worksheet_SelectionChange & then going to that range, but with no success.
I also looked at Worksheet_Activate, but again I had no luck as I don't know how to store the previous activecell, or pass that info on & then select it on the new sheet.
I thought it would be quite easy (& it may well be), but it isn't easy enough for me !!
thanks for any pointers