Hiding macros

  • Thread starter Thread starter Crispy
  • Start date Start date
C

Crispy

I have created a simple invoicing workbook that contains
a lot of macros. I would like to have the macros run in
the background while showing on the the main page an "In
progress" message which changes when complete to allow
the next invoice to be added.
Grateful for any help
Crispy
 
Crispy,

One way to do this would be to create a UserForm with
whatever message that you want displayed.
In the UserForm Activate Event, call your macros.

e.g.

Private Sub UserForm_Activate()
DoEvents
' Call your sub(s) here
Unload UserForm1
End Sub

John
 
Thank You
-----Original Message-----
Crispy,

One way to do this would be to create a UserForm with
whatever message that you want displayed.
In the UserForm Activate Event, call your macros.

e.g.

Private Sub UserForm_Activate()
DoEvents
' Call your sub(s) here
Unload UserForm1
End Sub

John




.
Click to expand...
 
Back
Top