Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Project Training and help » Macro for Formatting

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Macro for Formatting

Resolved · High Priority · Version 2003

Reply Tue 31 Mar 2009, 10:58Delegate Bob said...

Bob has attended:
Excel Advanced course

Macro for Formatting

I am unable to work the Macro Button set up on my PC to allow colour formatting of the bars.

THis was set up by your trainer on our last in house training.

please can you advise how I can get the Format button to work again.

The Colour bars were allocated to Task types.

Regards

Bob Meghani

For upcoming training course dates see: Pricing & availability

Reply Thu 2 Apr 2009, 10:07Trainer Jacob said...

RE: macro for Formatting

Hi Bob

Thanks for your post. From checking our records it looks like we provided some Excel training to your team back in July 2007.

It's hard to tell exactly what you have set up with regards to the macro, certainly sounds like the trainer created something for you on the fly as an informal solution to your request aside from the training you received.

To give us a better idea of what the issue is we will need to see the actual spreadsheet you are working on with the embedded macro.

Once we have reviewed it we may well find that the fix is only a matter of minutes. However we may well need more trainer time to reach a solution wand naturally we would inform you of any costs beforehand.

If you would like to send through your file for review, then please let me know.
Regards

Jacob

Reply Thu 2 Apr 2009, 10:30Delegate Bob said...

RE: macro for Formatting- MS Project

Jacob

Sorry - the in house training was for MS Project. The Macro's are on MS Project.

Training was late last year, can't remember trainer's name but it was a 1 to 1 specific to set up a Joinery Programe.

Your earliest contact would be apprecaited.

The file is 4mb, if you like I can send it to you if you give an e-mail address and explain what the problem is over the phone with it open.

Please advise at your earliest

Regards

Reply Thu 2 Apr 2009, 16:49Trainer Jacob said...

RE: macro for Formatting- MS Project

Hi Rob

Thanks for the clarification I have just sent you an email, we can take things from there.
Regards

Jacob

Thu 9 Apr 2009: Automatically marked as resolved.

MS Project articles

· Advanced Microsoft Project Training - manage your level of expertise
· Avoiding Project Failures
· Project And Excel: Perfect Partners
· Customizing Your In-House Project Server Training
· How To Save And View Multiple Baselines In Microsoft Project

Please browse our web site to find out more about
2003.microsoft.project.server and other Microsoft training courses.

Ms project tip:

Keep constraining dates to a minimum

As far as possible avoid fixing the dates of your tasks. For example try to steer of clear dragging task bars in the Gantt chart to move them on the timeline or entering dates directly into the Start / Finish fields.

Date constraints such as these limit Microsoft Project's ability to automatically adjust your project whenever you add, remove or modify the duration of your tasks. Instead use the logic in your task dependencies that link your tasks to enable Project to calculate the start and finish dates for you.

View all MS Project hints and tips