click on or hover on cell to enlarge temporarily

[lost in Chicago]

have no idea where to start on this one

 

[Gord Dibben]

You want to have a cell enlarge when you hover or click on it?

Unless this would be a new feature in Excel 2007, there is no such feature in
Excel.

How about a toggle button you click to Zoom the sheet to 200% then back to 100%?

Sub Toggle_Zoom()
With ActiveWindow
If .Zoom <> 200 Then
.Zoom = 200
Else: .Zoom = 100
End If
End With
End Sub

To run the macro on a double-click on any cell copy this to a sheet module.

Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
Call Toggle_Zoom
Cancel = True
End Sub

Double-click to Zoom, double-click to un-Zoom


Gord Dibben MS Excel MVP


On Sun, 2 Mar 2008 11:15:00 -0800, lost in Chicago <lost in