Marcos to run in current workbook only

[Tim Stoner]

Hi All
I am having issues where my macros run across in every book book instead of the current workbook only
I have gone to the macro setting under developer tab and set to the current workbook only but they all keep running on all books
How can I stop this and just have the macros run in the current workbook
Thank you in advance
Tim

 

[Legacy 456155]

I have always included an optional argument to keep public procedure off the list.

Example:
Public Sub MyMacro1()
Public Sub MyMacro2(Optional HideMacro As Boolean)

Open another workbook. You will not see MyMacro2 in the list of available macros.
Note that it is still available for assignment and calling.

 

[Tim Stoner]

I have always included an optional argument to keep public procedure off the list.

Example:
Public Sub MyMacro1()
Public Sub MyMacro2(Optional HideMacro As Boolean)

Open another workbook. You will not see MyMacro2 in the list of available macros.
Note that it is still available for assignment and calling.

Thank you for this ,but it also doesn't show macros in current workbook, if I use option 2,
I need to assign macro to a ribbon button
Tim

 

[Legacy 456155]

You can still assign it. Add the optional argument after you assign it. It will still call the macro after adding the optional arg.