2010年6月4日 下午 02:06
I recorded some simple macros in a Project 2010 schedule and when I sent it to a couple of team mates they could not see the macros. Enable macros was checked. They renamed the file and sent it back. I could see the macros. This was done from my laptop. I took the file to my desktop by way of thumb drive and could not see the macros. I appears that the macros can only be seen on the system they were developed on. I am running windows 7 ult.
It has been some time since I tried to share macros, what am I doing wrong or not doing?
2010年6月4日 下午 03:46版主
When you record a macro, Microsoft Project 2010 stores the VBA code in the Global.mpt file by default, and NOT in the project. This is why your users cannot see it when they open the file. Here's what you need to do:
- Open the project in question.
- Click the View tab to display the View ribbon.
- Click the Macros pick list and Visual Basic item on the pick list.
- In the Visual Basic window, click the expand button (+) to the left of the ProjectGlobal (Global.mpt) in the sidepane on the left side of the screen.
- Expand the Modules folder below the ProjectGlobal item.
- Drag the module in which you recorded the macro (probably called Module1) from the ProjectGlobal item to the project opened in step #1.
- Close the Visual Basic window.
- Save your project.
Hope this helps.
Dale Howard [MVP]
Dale Howard, MVP VP of Educational Services msProjectExperts http://www.msprojectexperts.com http://www.projectserverexperts.com We write the books on Project Server
- 已標示為解答 Christophe FiessingerMicrosoft Employee, Owner 2010年6月4日 下午 06:28
2010年6月4日 下午 05:29
You are correct they were stored as Global.
2010年6月4日 下午 07:41版主
2010年6月4日 下午 10:33BTW: When will your Project 2010 books be available? I checkd last week and they were not available.
2010年6月6日 下午 02:35版主
The What's New Study Guide to Microsoft Project 2010 is already available. Our Project Server 2007 book for administrators is ready to hit the market. Other books are in development, even as we speak! Thanks for asking. :)
2012年5月2日 下午 05:12
In our company we are using MsP 2010 and in the Organizer some of the individuals Modules tab is greyed out and some are not. Is there a solution?
2012年5月2日 下午 08:15版主
I would check to see if the Trust center settings are the same. File > Options, Trust Center button. Check the macro settings.
2012年7月23日 上午 11:32
Julie, I did the above description to adjust de Macro - security settings.
Now the tab developer is availble, but all the options are grayed out!
Therefor I can't select "Record Macro" "View Macro" etc...
Do You have a solution for this problem to, it would help me a lot!
thx in advance
2012年7月23日 下午 12:32版主
What did you adjust the macro settings to? No matter what I select, the developer tab and record macro is available.
2013年3月27日 下午 10:09
I would like to know if there is a macro that does the following:
save .mpp file of several schedules on the project server using project pro 2010.