Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try this:
Create a folder on the server called Common and save an Excel spreadsheet with all the macros in this new folder. For each user, open Excel and from the Tools menu, select Options. On the General tab, click in Alternate Startup File Location and type in the path to the new folder. The spreadsheet will open and be hidden every time they open Excel. Hope this helps, Helen -----Original Message----- I can save Macro's by attaching to the workbook its used in or in my personal folder. I am trying to find out how to save macro's in a common personal folder for all users in the office. The save in macros doesn't allow one to browse out. Let me know, Daria . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macros common to several workbooks | Excel Worksheet Functions | |||
Templates - saving in specified folder | Excel Discussion (Misc queries) | |||
can't open excel files from common folder | Excel Discussion (Misc queries) | |||
Preventing users from saving a spreadsheet | Excel Discussion (Misc queries) | |||
saving macros to a common folder for all users | Excel Programming |