ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sharing Macros (https://www.excelbanter.com/excel-worksheet-functions/256775-sharing-macros.html)

enna49

Sharing Macros
 
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

Jacob Skaria

Sharing Macros
 
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



All times are GMT +1. The time now is 07:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com