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.
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.
Last edited by extremis; 05-01-2013 at 03:23 PM.
Delete the private prefix to the other subs
Elegant Simplicity............. Not Always
Private prefix to the other subs..sorry I am learning right now, could you show me what do you imply?
you mean the sheet("sheet2") ??
so it should like that?
Well...it doesnt work...and both FilterCHISETUPPPLAPOC and refresh macro work. I tested themPlease Login or Register to view this content.
Last edited by extremis; 05-01-2013 at 02:16 PM.
Maybe:
Please Login or Register to view this content.
Nope......nice try tough ...
the macro seem to stay on sheet 1...for some reason..-_-
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.
Last edited by AndyLitch; 05-01-2013 at 02:31 PM.
Not on private mode..already
alright...on sheet1
on sheet2Please Login or Register to view this content.
Please Login or Register to view this content.
on sheet3
Please Login or Register to view this content.
Last edited by extremis; 05-01-2013 at 02:37 PM.
So, what do you think? macro on sheet 2 and 3 work. I tested the macros...
sheet1 macro calls the other 2.............
So you should only need to call the sheet 1 macro
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.
ok it work...
explain me that PLEASE....how to put it on a module it just make it work?
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
you know where i can find more of thoses course? I would like to teach myself VBA.
pretty useful
Sure there is a wealth of information on the internet about free online courses. Just Google VBA. Also this website is very helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks