Macro Toolbar, disable buttons

[ioncila]

Hi
I created a toolbar that calls all the macros in a workbook. This toolbar appears in all activesheets because all sheets in this workbook have macros to run.

My question is:

Is there a way to disable (or hide) macro buttons of the toolbar if their macros dont belong to the activesheet (this to prevent execute macros from another sheets)?

I would aprecciate some help

Thank you very much

 

[GTO]

http://vbaexpress.com/forum/showthread.php?t=25808

 

[ioncila]

Hi
I created a toolbar that calls all the macros in a workbook. This toolbar appears in all activesheets because all sheets in this workbook have macros to run.

My question is:

Is there a way to disable (or hide) macro buttons of the toolbar if their macros dont belong to the activesheet (this to prevent execute macros from another sheets)?

I would aprecciate some help

Thank you very much

I wish I could get some help