Two Macros in Only One Button

[Arun C M]

Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have created a Macro File that will be used by all, that will contain many operations and it integrates with other applications also; so I have prepared Operation Manual in PDF.
When person needs a help for any operation then that “Operation Manual” should open.
To this I have created two buttons attached with Macro (One for Open One for Close).
Are there any possibilities I can create one Hyperlink or Macro in Only One Button.
Process: If user clicks first time Help file as to Open If user clicks second time Help file as to close.
<o></o>
Thanks in advance
<o></o>
Arun C M

 

[SteveO59L]

you could link your code to a cell and based on the state of that cell, conditionally run the code

 

[cornflakegirl]

In the Control Toolbox there is a toggle button - this remembers what state it's in, so you don't need a separate cell to do that. You can call different code depending on whether the button is True or False, and can also change the caption on the button:

Private Sub ToggleButton1_Click()

If ToggleButton1.Value = True Then
    MsgBox "Your help file code here"
    ToggleButton1.Caption = "Close help file"
Else
    MsgBox "Your close code here"
    ToggleButton1.Caption = "Open help file"
End If

End Sub