Double click zoom, unzoom
Hi,
I would like to be able to double click a cell, and have the selected cell move to A of that row
(ex: double click cell C27, moves selection to A27)
and, Cause the worksheet to zoom to view Columns A:D
And when anything is double clicked again, it will zoom out to view columns A:G
Any help is appreciated as always.
You'd have to configure the zoom % yourself to meet your needs, as your Column and Row width and height could be just about anything.
This code goes directly on the worksheet you apply it to, by right clicking the tab and choosing View Code.
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
I modified it a bit so that I could have the results that I wanted from the zoom, But..
When I zoom, it brings me back to A7, and I want my selection to stay on the row of the cell that I double clicked so that I don't lose my place while zooming in..
Thanks for the help!
Heres what i ended up with, Zoom works great (thank you)
Please Login or Register to view this content.
You can capture the ActiveCell.Row for the targeting.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks