Command Button Query

[Wayne Rogers]

I have around 15 different sheets in one of my spreadsheets, each running a different macro.

I want to have a main sheet with several command buttons (active x) that will run the associated macro on the relevant sheet.

i.e. the gross profit button when pressed on the main page will run the gross profit macro on the gross profit tab/sheet.

Many thanks

 

[JoeMo]

I have around 15 different sheets in one of my spreadsheets, each running a different macro.

I want to have a main sheet with several command buttons (active x) that will run the associated macro on the relevant sheet.

i.e. the gross profit button when pressed on the main page will run the gross profit macro on the gross profit tab/sheet.

Many thanks

Can be done but you need to ensure that the macro on the relevant sheet is written so that it does not require the sheet to be active to get the desired results when the macro runs. If the macros are in standard modules (not sheet event code) you can use form control command buttons and just right click the button to assign a specific macro to it.

 

[Wayne Rogers]

Hi Joe,

Thanks for your reply, Ive just put a form control button on the main page and assigned it, however it runs the macro on the main page not on the gross profit page/tab as desired.

 

[JoeMo]

Hi Joe,

Thanks for your reply, Ive just put a form control button on the main page and assigned it, however it runs the macro on the main page not on the gross profit page/tab as desired.

That's what I tried to point out in my reply (Post #2). You either have to re-write the macro or start it with:

Application.screenupdating = false
Sheets("The Sheet Name of the sheet to run the macro on here").Select

and end it with:
Sheets("The main sheet name here").select
Application.screenupdating = true

 

[Wayne Rogers]

Hi Joe,

Works a treat, thank you very much for your help with this.

I'm new to using macros and vba and I'm currently looking for a good source of training to help me gain some basic knowledge.

Once again thank you.

Wayne

 

[JoeMo]

Hi Joe,

Works a treat, thank you very much for your help with this.

I'm new to using macros and vba and I'm currently looking for a good source of training to help me gain some basic knowledge.

Once again thank you.

Wayne

You are welcome - thanks for the reply.