Turn Off Cursor and show hourglass

G

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?
[email protected]
 
D

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.
 
D

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!)
 
Top