View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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