yes, it is possible to trigger a macro with so-called "task events" or "resource events". They fire e.g. when a task is created, deleted, etc.
Copying in the way that you propose does not work for my users, as I there are several 100 people using MSP, most of them only occasionally. So I cannot teach them that this tool behaves differently than Excel, which they are all familiar with. I need to find a solution to catch copy/paste via macro.
Any other ideas? Thanks a lot!
Member for
20 years 7 months
Member for20 years7 months
Submitted by Niek Zonneveld on Mon, 2011-09-19 14:19
I don't think you can just trigger a macro, other than by using a shortcut key (<ctrl> + <key>) or an mpp file that kicks off a macro when it opens.
Instead of going down the macro-route it's probably better to avoid the problem.
A way to circumvent copying 'hidden' information is to copy and paste only the cells/info you need, instead of the entire line. This works quite well except for precedence relations. If I want to reuse information from other schedules, I normally only copy the name and duration fields, just to make sure I don't introduce any other rubbish.
Member for
14 years 6 monthsNick, yes, it is possible to
Nick,
yes, it is possible to trigger a macro with so-called "task events" or "resource events". They fire e.g. when a task is created, deleted, etc.
Copying in the way that you propose does not work for my users, as I there are several 100 people using MSP, most of them only occasionally. So I cannot teach them that this tool behaves differently than Excel, which they are all familiar with. I need to find a solution to catch copy/paste via macro.
Any other ideas? Thanks a lot!
Member for
20 years 7 monthsMartin,I don't think you can
Martin,
I don't think you can just trigger a macro, other than by using a shortcut key (<ctrl> + <key>) or an mpp file that kicks off a macro when it opens.
Instead of going down the macro-route it's probably better to avoid the problem.
A way to circumvent copying 'hidden' information is to copy and paste only the cells/info you need, instead of the entire line. This works quite well except for precedence relations. If I want to reuse information from other schedules, I normally only copy the name and duration fields, just to make sure I don't introduce any other rubbish.
H.T.H.