Hiding macros

[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

 

[John Wilson]

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

 

[Crispy]

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




.