Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
click on or hover on cell to enlarge temporarily
have no idea where to start on this one
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - how to hover over a cell and have a value show up | Excel Discussion (Misc queries) | |||
Enlarge picture in a cell comment, PLZZ some advise | Excel Discussion (Misc queries) | |||
enlarge a single cell | Excel Discussion (Misc queries) | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Click on cell-calendar drops down-click on date-date fills cell. . | Setting up and Configuration of Excel |