hourglass remains after macro runs???
Hi Elizabeth,
Your code ran without problem for me, irrespective of whether it ran from
the VBE or in response to a shape click event.
Of course, in either case, the macro cannot terminate until the message box
is closed.
---
Regards,
Norman
"Elizabeth" wrote in message
...
when i run the following code from the VBE (F5), it runs fine. when i run
it
from a rectangle i drew on a spreadsheet in the same file, the hourglass
remains on the screen until the OK button or Close "X" is clicked.
Sub StartupPath()
MsgBox Application.StartupPath, Title:="The Excel startup path is: "
End Sub
what is causing the hourglass to remain after the msgbox is displayed?
thank you.
elizabeth
|