Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Accessing macro from a system by all other nodes on LAN
I have created a macro in a worksheet and stored in C:\program
files\MSOffice\Office10\XL Start folder. Now I want to execute the macro whenever MSExcel is started from, the system on which it is stored and also on other systems in the network. Request to guide me in solving the above query. Any changes to the macro shall be made only in the system where it is stored. NSNRao -- reply to my posts are welcome |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Accessing macro from a system by all other nodes on LAN
First, don't name your macro workbook personal.xls.
Give it a nice unique name: NSRUtils.xls Then distribute it to your coworkers and tell them to put it in their XLStart folder--if you really want them to be able to update the macros in that workbook (I'm confused about what a system is in your post). If you want to be the only person who updates the workbook, then save the workbook as an addin, mark it readonly and store it on a common network drive. Tell the other users that they should use tools|addins and browse to that location using the UNC path--not the mapped drive letter--to install it. But once you save the file as an addin, the macros won't appear in the Tools|Macro dialog. You'll need to provide an interface for the users so that they can run your macros. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm In xl2007, those toolbars and menu modifications will show up under the addins. NSNR wrote: I have created a macro in a worksheet and stored in C:\program files\MSOffice\Office10\XL Start folder. Now I want to execute the macro whenever MSExcel is started from, the system on which it is stored and also on other systems in the network. Request to guide me in solving the above query. Any changes to the macro shall be made only in the system where it is stored. NSNRao -- reply to my posts are welcome -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
accessing outlook data using excel macro | Charts and Charting in Excel | |||
x-axis dates dont match up with the nodes on the line graph | Charts and Charting in Excel | |||
error accessing system registry | Excel Discussion (Misc queries) | |||
How to write a macro to get the system time in excel 97 | Excel Discussion (Misc queries) | |||
excel causing system to be in low system resource | Excel Discussion (Misc queries) |