Link to home
Start Free TrialLog in
Avatar of itsmevic
itsmevicFlag for United States of America

asked on

Excel 2010: VBA Macro that Automatically Zooms in and Out & highlights your cell selection upon clicking the cell.

Hi Experts,

  Curious if anyone has a VBA laying around that they could share that will do the following:

1.)  Will highlight a cell any color of your choosing when it is clicked on, then when you click out of it onto a new cell it changes it back to it's  
       original color but highlights your next selection you clicked on?

2.)  Will zoom in slightly to each cell when clicked on.  For example if the resolution is already set at 100% when clicked on it increases it to
       say, 120%.

  If I had these features I think it would be easier for my audience visually (and me too).  The name of my worksheet is "Test".

I found something, but it's not quite working on my worksheet:

Private Sub test(ByVal Target As Range)

If ActiveWindow.Zoom <> 100 Then
ActiveWindow.Zoom = 100
Else
ActiveWindow.Zoom = 200
End If
End Sub
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of itsmevic

ASKER

Will try these suggestions and let you guys know.
Thank you both!