Allow macro#2 to run if Macro #1 complets

[sb003848]

Hello,

I'm using 2 macros in my Excel document (these macros are launched using buttons on my Sheet).

Macro #1 looks at different cells and informs the user if all needed cells are filled out. If they are, then they can go ahead and launch macro #2. If not, then I don't want to allow them to launch macro #2.

Can this be done?

 

[Trevor G]

What code are you currently using, as you would combine an If statement with a Call statement

If Macro1 ----------- then
call Macro2
Else
Exit Sub
End IF