Turn Off Cursor and show hourglass

[Guest]

I have some code that opens a new Excel and sends some stuff, formats it, etc.
Problem is on long exports, they can mess it up if they do something with the
cursor, like select another Excel doc they're working on.

Is there a way to turn off their keyboard and mouse with VBA, and even show a
status bar or hourglass?
(e-mail address removed)

 

[Douglas J. Steele]

DoCmd.Hourglass True (then DoCmd.Hourglass False to turn it off), or you can
set the MousePointer property of the Screen object.

 

[Ken Snell [MVP]]

This won't "turn off" the keyboard and mouse clickers, though.

 

[Douglas J. Steele]

You're right, of course, Ken. I must have read too quickly, and only caught
the hourglass bit. (I missed the status bar as well!)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

 

[Guest]

Well, is there a way to kill stop cursor and keyboard movement?
(e-mail address removed)