Hi
I've had a look around and can find anything really helpful.
I want to automatically centre and zoom in/out the worksheet on certain chosen cells.
For example:
A user enters/select cell, say "J76", and i want the page to centre on cell J76 and then zoom in to 150%, wait a few seconds and zoom back to 100% Then they may enter "B34" and then the page will recentre on B34, ETC.
Hopefully I've explained myself
Thanks for any help.
BP
I've had a look around and can find anything really helpful.
I want to automatically centre and zoom in/out the worksheet on certain chosen cells.
For example:
A user enters/select cell, say "J76", and i want the page to centre on cell J76 and then zoom in to 150%, wait a few seconds and zoom back to 100% Then they may enter "B34" and then the page will recentre on B34, ETC.
Hopefully I've explained myself
Thanks for any help.
BP