Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Share Macro
I have a program which e-mails xls files to various employees attached
to our network, all of whom have a locally installed copy of excel. Proper printing of the file requires a short macro which I have written. When an employee opens the file (these are new each month) I would like to be able to share the macro over the network. If this is not possible what is the easiest way to copy the macro to each excel program? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Share Macro
Some thoughts:
1. You could put the macro in the files that are mailed (Best way). 2. You could send a file with the macro in it and tell the users t open it before running the print function (may need to change macro fo this). 3. You could put the macro in a spreadsheet on a shared directory an set each user's Excel up to open files from this directory when openin excel (Tools | Options | General, put directory in the At startup, ope all files in:). 4. You could edit each user's personal.xls (or create if they don' have one). This would take the longest... -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro on Share Protection | Excel Discussion (Misc queries) | |||
Share Macro | Excel Discussion (Misc queries) | |||
Share a macro | New Users to Excel | |||
I recorded a macro, how can i share it with others? | Excel Worksheet Functions | |||
How can I share a macro with other users in the network within a . | Excel Worksheet Functions |