Open Macro after Close

  • Thread starter Thread starter Gerry Kuta
  • Start date Start date
G

Gerry Kuta

I have a 'form open macro' that I'd like to come up
after "Close" is pressed on the form?
Does any one know how without restarting the file?
Private Sub Workbook_Open()
With Sheets("Sheet1")
Application.Goto .Range("A2")
.ShowDataForm
End With
End Sub
TIA
Gerry
 
Data... Forms does bring it up BUT I'd like to know if it
a VBA procedure could bring it up on right click...
analagous to Orlando's calendar!
TIA
 
Back
Top