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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form/Highlight row 2
Excel VBA - Problem with Closing Print Preview 0
Where best to place an instruction in a VBA script 4
Pivot Table Macro 1
2 Macros running on same module 2
Access Sub form opens before the main form in MS Access 0
Open workbook to same worksheet and next empty row 3
losing command button functionality 4

Back
Top