PDA

View Full Version : Select cell before sheet deactivate



Mr.G
05-25-2010, 07:29 AM
Hi

I must be missing something stupid here.......before a sheet deactivates I want to select Range("IV1").

I have a index sheet that has hyperlinks to various other sheets in the workbook and I want make sure that when you follow the hyperlink that the cell is displayed on the left of the screen. I am thinking that to select the last cell in Row "A" before you close a sheet will give you the result........I could be wrong.

If you have knowledge to share regarding this, pls help.

Thank you.