Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maintaining Macros on a sheet when it is saved as a new workbook
I have an application where via one macro the user can double-click on
a specific cell and it pops up a TextBox with a definition. Then they can click on the TextBox to close it. Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) 'displays definition with a live example If ActiveCell.Address = "$B$3" Then Cancel = True With ActiveSheet .Shapes("Group1").Visible = True End With ElseIf ActiveCell.Address = "$J$3" Then Cancel = True With ActiveSheet .Shapes("Group4").Visible = True End With End If End Sub Then through a separate macro the user can click on the TextBox to close it. Sub CloseTB1() With ActiveSheet .Shapes("Group1").Visible = False End With End Sub These both reside on a sheet-tab named "Report". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete all macros if workbook is saved with another name | Excel Worksheet Functions | |||
hyperlink to sheet in workbook saved as html | Excel Discussion (Misc queries) | |||
Running & maintaining macros remotely | Excel Programming | |||
Hyperlink to specific sheet; workbook saved as html | Excel Worksheet Functions | |||
How to execute macros not saved in a workbook | Excel Programming |