Turn Off Cursor and show hourglass

  • Thread starter Thread starter Guest
  • Start date Start date
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?
(e-mail address removed)
 
DoCmd.Hourglass True (then DoCmd.Hourglass False to turn it off), or you can
set the MousePointer property of the Screen object.
 
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!)
 
Back
Top