ExcelBanter - click on or hover on cell to enlarge temporarily

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
wrote:

have no idea where to start on this one