disable button if cell is >0

[hqradio]

Hi there!

Im quite new to excel, this might be an easy one!

i wanto be able to disable a button (macro) if a certain cell is >0,
we have a macro that prints the worksheet, then we have another macro that creats a new worksheet, i want that the macro trhat creates the new worksheet shud not work till the current worksheet is printed.

thanks for the help!

[jeffreybrown]

Why not put a Call to the second macro at the end of the first macro?

[hqradio]

Why not put a Call to the second macro at the end of the first macro?

as i said: im quite new to excel so please explain.

thanks for the quick reply though

[jeffreybrown]

Here's an example.

One button is attached to the first macro and a second button to the second macro.

If I press the first button it will run and then call the second.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[hqradio]

Thanks a million!! ur great!
Can you try to help me on my other post that i started and no1 answered yet?!
That'll be super!