Enterprise level macros? Automated macros?

[H20Polo Pascal]

I have created some view-formatting macros while in the Enterprise Global
environment. I then created a toolbar for these in the same environment.
When I log off and back in, I can see the toolbar and the macros run when I
select the appropriate button. I had an existing user login to see if they
too could see these items created in Enterprise Global. They could not see
the macros or the toolbars. How can I make these changes global? Is it only
automatic for users that were created after the toolbars were developed? If
so, can I reset existing users defaults?

Secondly, is there a way to associate a macro to a view (or any existing
menu item / button) in such a way that when a view is selected from the menu,
the macro is automatically run without having to select it each time? My
macros contain the view change in them, but I don't want to have to create a
new macro for each view. I want to be able to associate common macros to
existing views and automate the process.

 

[Rod Gill]

Toolbars, menus and macros need to be in the Enterprise Global file. You
need to close project then reload to download latest Enterprise Global.
Create a menu with each item calling a separate macro that in turn displays
and formats the View. However, in Project Server it is much better to create
different views in the Enterprise global as these are then fixed. No need
for a macro at all.

What formatting are you doing?

 

[H20Polo Pascal]

Rod,

Thanks for the update. What do you mean by reload? The formatting I am
trying to perform is changing fonts, graphical settings, sorting data, etc.
I know in views you can select Groups, Tables, and Filters. I don't know any
other way to select preset formats. Maybe you could suggest an alternative
solution.

Regards,

Pascal Cohen-Hadria
Dell PMO

 

[Rod Gill]

Don't the Text Styles work for you? Sorts do require a macro if users are
incapable of selecting Project, Sort themselves.

 

[H20Polo Pascal]

I know how to use Text Styles, but did not know they were associated with
view or tables. If so great. My only concern is that if the text style used
in one view is different than the other, will selecting the view change it,
or will a macro be required.

Also, to my previous question, how do I reload Enterprise Global as you
suggested to do?

Thanks for your assistance.

Pascal Cohen

 

[John Sitka]

Get comfortable organizing in the VBA explorer,

Notice if you want to create a Macro to reside in the Enterprise Global you may need to create the Macro in a Project other than the
Enterprise Global, just because looking at an empty project is often hard to determine correct results.
So you may have three different VBAProjects open and each macro may go in a different module. If you go to the explorer view open
all the nodes and modules you can see where the macro you created actually ends up, there will probably be a bunch of other ones to
from past attempts. Looking at the creation of macro's or custom code this way gives inight into the "STATE" of when the code is
available and where it resides.
Instances are not expressly declared in VBA, the application is assumed as the base instance.
So upon creation "store macro in Global file / this Project" may not put you in the correct place to create the macro and get it
into the Enterprise Global.
It may give you object names like Enterprise GLobal!macro1 and macro1 simultaneous. The pattern becomes obvious when you practice a
few, don't tolerate a bunch of meaningless modules and keep the code organized. Often it is as easy as coping and pasting the code
from where it was generated into the VBAProject(Checked-out Enterprise Global)+ Microsoft Project Objects+ThisProject (Checked-out
Enterprise Global) node.

 

[H20Polo Pascal]

Still need to determine how to reset Enterprise Global for all users as per
Rod's suggestion.

 

[John Sitka]

This isn't as clear as it could be..


Build the code in any project, copy/paste raw code to checked out Enterprise global.
Users exit Project then reopen.
The even from a new Project1 the code that is contained in VBAProject(Checked-out Enterprise Global)+ Microsoft Project
Objects+ThisProject (Checked-out
Enterprise Global) will be in...
VBAProject(Global(+cached Enterprise))
-Microsoft Project Objects
--TheProject(Global(+cached Enterprise))
for all to use

It's like a tree, much like the VBA Explorer.
The code can reside in the base (not module) Enterprise global VBA Project and it will propagate.
For a finer level of control Enterprise code can exist in separate module(s) within the Enterprise global VBA project
and then the module(s) can be made available via the organizer.