Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving / sharing Macros between workstations
Using Excel 2000 / Small Business Exchange Server / XP Pro
I created a simple macro in Excel 2000 and assigned the macro to a custom menu item on the toolbar. I believe I stored the macro in the personal workstation choice, but could change that. How do I share that macro with other workstations? In Word I am accustomed to using Organizer for this purpose to copy my current macros to a named module. Then copy that named module to my document template on the server drive and copy and paste from said template to each workstation Normal.dot individually. The Excel worksheet I am working in resides on the server drive. The worksheet/book is not shared and I do not want to do so. Thank you for your help. -- John R. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving / sharing Macros between workstations
Store the macro in the workbook instead of in Personal.xls. Then make
a button in the workbook instead of in your toolbar. You can make buttons either with a Text Box (allows for different colors/shapes) or just choose Button from the Forms toolbar. Whichever you choose, pick Assign Macro (similar to what you did for a toolbar button) and you'll be all set. You may (almost certainly) have to go around and get people to change their Macro Security settings. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving / sharing Macros between workstations
Thank you. This is very helpful.
-- John R. "Spiky" wrote: Store the macro in the workbook instead of in Personal.xls. Then make a button in the workbook instead of in your toolbar. You can make buttons either with a Text Box (allows for different colors/shapes) or just choose Button from the Forms toolbar. Whichever you choose, pick Assign Macro (similar to what you did for a toolbar button) and you'll be all set. You may (almost certainly) have to go around and get people to change their Macro Security settings. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sharing macros | Excel Discussion (Misc queries) | |||
Moving / Sharing excel files with queries | Excel Discussion (Misc queries) | |||
Sharing Macros | Excel Discussion (Misc queries) | |||
Sharing workbook with macros | Excel Discussion (Misc queries) | |||
sharing macros | Excel Discussion (Misc queries) |