-
Select cell before sheet deactivate
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules