how i am able to apply a macro to a particular workbook

[Ankur Kumar]

Hi All,

Love from india,

I am looking to how i am able to apply a particular VBA macro to a particular workbook when ever i open a workbook so only that Macro show which apply on that sheet in my NEW TAB as i have applied a clear content macro to different workbook but in every workbook it is showing i need that only that vba macro shows which pertain to that workbook.

Thanks in advance

 

[Kenneth Hobson]

I don't know what you mean.

Do you mean the macros listed in the ribbon Developer > Macros? There is a dropdown option to pick which workbook macros you want listed/shown.

Of courses Private macros in worksheets won't be listed there.