Create an event to auto-answer an alert

[Brian Lukanic]

Is it possible to create a VBA module that will auto answer an alert message
upon a file open?

Specifically, I am using hammock tasks in Project. When you re-open the
file, an alert appears asking if you want to re-establish links. I consider
this a nag screen and I'd like to have a VBA event aiutoanswer yes whenever
this window appears. There is a way to turn off the nag screen in Options,
but this effectively also tells Project to *NOT* update links. I want to
update links upon every open and not have this screen appear to our users. It
would seem like a VBA module should do the trick buy I am not completely sure
of what the syntax would need to be.

 

[John]

Is it possible to create a VBA module that will auto answer an alert message
upon a file open?

Specifically, I am using hammock tasks in Project. When you re-open the
file, an alert appears asking if you want to re-establish links. I consider
this a nag screen and I'd like to have a VBA event aiutoanswer yes whenever
this window appears. There is a way to turn off the nag screen in Options,
but this effectively also tells Project to *NOT* update links. I want to
update links upon every open and not have this screen appear to our users. It
would seem like a VBA module should do the trick buy I am not completely sure
of what the syntax would need to be.

Brian,
You might want to check my last response to your post in the main
newsgroup. If you still have an issue, then maybe you can entertain some
type of Open Event macro using the SendKeys statement.

John
Project MVP

 

[Brian Lukanic]

John,

You are right, I think I am set. I do have Rod Gill's VBA book and am
starting to tinker, but in this case I think the simple setting change in
Options will do the trick.


Thanks!

 

[John]

John,

You are right, I think I am set. I do have Rod Gill's VBA book and am
starting to tinker, but in this case I think the simple setting change in
Options will do the trick.


Thanks!

Brian,
You're welcome and thanks for the feedback.

You know, reading Rod's book will make you a very dangerous person.....
just like we are.....

John
Project MVP