macro from sheet1, executing macro from sheet 2 and 3

[extremis]

Hi,

basicly, on sheet 1 i have this macro. I want that it execute the macro on sheet number 2 and number 3...but it doesnt work..

Please Login or Register  to view this content.

[AndyLitch]

Delete the private prefix to the other subs

[extremis]

Private prefix to the other subs..sorry I am learning right now, could you show me what do you imply?

[extremis]

you mean the sheet("sheet2") ??

so it should like that?

Please Login or Register  to view this content.

Well...it doesnt work...and both FilterCHISETUPPPLAPOC and refresh macro work. I tested them

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[extremis]

Nope......nice try tough ...

the macro seem to stay on sheet 1...for some reason..-_-

[AndyLitch]

On the other sheets the subs will usually by preceded by Private ... e.g. Private Sub Extremis()
I think if you delete the private element you can call them from other sheets. e.g. Sub Extremis()

If that doesn't work you'll have to move the other subs into a code module and the first line of code for each will need to activate the relevant sheet.

[extremis]

Not on private mode..already

[JOHN H. DAVIS]

Nope......nice try tough ...

the macro seem to stay on sheet 1...for some reason..-_-

Is the code you mention on Sheet1 Event Code for Sheet1? If possible can you post the code you have?

[extremis]

alright...on sheet1

Please Login or Register  to view this content.

on sheet2

Please Login or Register  to view this content.

on sheet3

Please Login or Register  to view this content.

[extremis]

So, what do you think? macro on sheet 2 and 3 work. I tested the macros...

[AndyLitch]

sheet1 macro calls the other 2.............
So you should only need to call the sheet 1 macro

[JOHN H. DAVIS]

Is your code in the Sheet Module or a Standard Module? I think you want your code in a Standard Module. Go to your VBA Editor and Insert a Module. Copy and paste the above code there. Then try to call it.

[extremis]

ok it work...

explain me that PLEASE....how to put it on a module it just make it work?

[JOHN H. DAVIS]

Here is a great on-line course about macros from microsoft. It has a section explaining how to insert a standard module and place your macros there.

http://office.microsoft.com/en-us/tr...22986&client=1

[extremis]

you know where i can find more of thoses course? I would like to teach myself VBA.

pretty useful

[JOHN H. DAVIS]

Sure there is a wealth of information on the internet about free online courses. Just Google VBA. Also this website is very helpful.