event procedure

[Matija]

Hi everyone,

I am looking for an event procedure that will enable me, with a click of a button on Sheet1, to call Private subs from Sheet1, Sheet2, etc.

Something like this:

Please Login or Register  to view this content.

Program1 is on sheet1
Program2 is on sheet2

Best regards

[royUK]

Put the macros into a standard module, not the sheet module & remove private

[Matija]

would then I be able to solve my problem?

[Matija]

hi, royUK i did how you instructed me to do, but i still have to press a button on each sheet that i want the macro to run.

[royUK]

Your original question said that you wanted to run the code from a button.

[Matija]

my question is how to run a makro, now in a standard module, on multiple sheets, despite it is started by button click on one sheet.

[royUK]

Do you mean to run it on each sheet at once?

[Matija]

at once or can I say miliseconds apart

[royUK]

The only way would be to loop through each sheet. Time taken will depend on th code.

Attach the workbook

[Matija]

here it is. I deleted something, but there is still everything needed. I want to run those two macros in standars modules in both sheets at once.

[royUK]

As I said the time taken will depend on the efficiency of the code, Your code requires selecting the sheets because you use Active Cell. This will slow the code down and could probably be avoided, as could the loops in the code.

You need something like this

Please Login or Register  to view this content.

[Matija]

it is the same as before the program runs in active sheet where the button is. did that work for you to run macro in both sheets?

[Matija]

sorry didn't post it under the right button i will try again

[royUK]

I didn't run the code, I know if a loop will work

[Matija]

it works, you helped alot.

Best regards

[Matija]

i rated you if that helps you. What did you mean by that i could had avoided those loops. Is there some other way.

Best regards

[royUK]

Your actual macros have loops which could probably be avoided, but I haven't time to check it out at the moment