Restrict two macro run at same time

[ashokbioinfo]

Hi,
I have created one macro for creating new sheet and print the data in pdf using another macro. I have used shortcut key also.

When I run the first macro, it works fine. But when click button on second macro, at the same time first macro also run. How to restrict.

Advance thanks

[marreco]

Hi..
Post your code in the forum

[mikerickson]

When a macro is running the user interface is disabled, you can't click a button while a macro is running.

[wakdafak]

please check the button call