PDA

View Full Version : Calling macros



tofimoon4
06-26-2011, 01:13 AM
Dear sir,with best regards,i have in my worksheet about (10 ) macros ( macro1,macro2,....etc.),i need a way to call any one of them and activate it .
Many thanks in advance.

Bob Phillips
06-26-2011, 01:31 AM
Put some buttons on the spreadsheet and assign the macros to them.

tofimoon4
06-26-2011, 02:27 AM
Dear sir,with my thanks,i know this way but i need a ( drop down list ) containing these macros ,if i need to activate any one i shall press its no.
My regards.

Bob Phillips
06-26-2011, 05:11 AM
Excel already provides one, Tools>Macro