I have a macro to be released to a number of positions held not by the same
person.
This is to be run with a New Worksheet with data created from SAP, so
therefore cannot be a Macro assigned to a Worksheet?
Personal is out and
"Assigned to a ToolBar" I do not think is the answer.
Is there something I am missing about "How to Assign a Macro",
Thanking you

A

How about using an Add-In. Check out

http://www.fontstuff.com/vba/vbatut03.htm

--
Jacob


"enna49" wrote:

I have a macro to be released to a number of positions held not by the same
person.
This is to be run with a New Worksheet with data created from SAP, so
therefore cannot be a Macro assigned to a Worksheet?
Personal is out and
"Assigned to a ToolBar" I do not think is the answer.
Is there something I am missing about "How to Assign a Macro",
Thanking you

A