?
Solved

Personal Macro Workbook Server Location?

Posted on 2010-01-05
5
Medium Priority
?
972 Views
Last Modified: 2012-05-08
Is it possible to save a Personal Macro Workbook to a server location so that multiple users can share the Macros in the book?
0
Comment
Question by:BelgianPhilip
  • 3
  • 2
5 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 26179256
Yes, but everyone apart from the first person to open it will get a warning about opening it read-only. I don't know if that's an issue?
It would be better, IMO, to create an add-in and distribute that to the users, though you will need to add a menu system to run the macros since add-in macros do not appear in the macros dialog.
0
 

Author Comment

by:BelgianPhilip
ID: 26179670
Thanks - it would actually only be 1 user who would actually use the shared book - but on multiple PCs - does that make a difference?
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 26179803
That would be fine then, assuming he only uses one at a time. I do in fact have my Personal.xls workbook stored on a network directory which is then listed in Excel Options, under the Advanced section in the 'at startup open all files in' setting.
0
 

Author Comment

by:BelgianPhilip
ID: 26180648
Thanks for your help - will it be possible to add macros to the book from any of the PCs and the changes reflected on all of the PCs?
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 total points
ID: 26180881
Yes - they will all access the same copy of the workbook.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question