Resource Leveling - Ignore a messagebox

[Yoav]

I wish to create a macro that runs Resource Leveling.
In some cases (e.g. when resource is not available) I get a messagebox:
"Project cannot resolve the overallocation of "Name of resource" on 'date'. I
can Skip, Skip All or Stop.
How can I automaticaly Skip All?

 

[Jan De Messemaeker]

Hi,

Before the levelnow instruction put
displayalerts=false

Hope this helps

 

[Yoav]

Hey, thanks!
Does it Skip, Skip All or Stop?
Ca I control the choise?

 

[Jan De Messemaeker]

Hi,

It skips all.
If you want to control the choice you have to use an othe rmethod (keeping
display alerts true but use=ing the sendkeuys instruction - read all about
it in the help, not obvious!
Hope this helps,

 

[Yoav]

Thanks!
you are the best.

Hi,

It skips all.
If you want to control the choice you have to use an othe rmethod (keeping
display alerts true but use=ing the sendkeuys instruction - read all about
it in the help, not obvious!
Hope this helps,

 

[Rob]

Did you ever creae the marco and does it work?

 

[Jan De Messemaeker]

Who is this message addressed to?
If to me, I must have written over the past 10 years something like 15000
Lines of VBA code and it did work, why?