form.show switches to debug mode
 

Hi all, I'm hoping you might be able to help me.

I have a button on a worksheet then runs a small macro with the text

usrSlctEng.show

where usrSlctEng is a user form. When I click on the button I am taken
into the VB editor and the line usrSlctEng.show is highlighted in
yellow. When I click the play button on the standard tool bar my form
shows as normal.

Now this happens with any form, any macro, and button and any
worksheet. but only occurs with the line <formname.show. I have been
working on this workbook for two weeks and it has only started happening
this afternoon. Also i have cleared all breakpoints.

Can anyone suggest anything that might fix this problem?

Cheers
Chris


--
rooch84
------------------------------------------------------------------------
rooch84's Profile: http://www.excelforum.com/member.php...o&userid=26996
View this thread: http://www.excelforum.com/showthread...hreadid=402008

form.show switches to debug mode
 

Chris,

I've seen breakpoints that sometimes linger around if you save a file with
the breakpoint in. Not sure why. Try adding and removing a breakpoint to the
offending line a few times, then save the file, exit excel, open the file,
try again.

If that doesn't solve it, export the module in question, remove it, then
import it again.

Robin Hammond
www.enhanceddatasystems.com

"rooch84" wrote in
message ...

Hi all, I'm hoping you might be able to help me.

I have a button on a worksheet then runs a small macro with the text

usrSlctEng.show

where usrSlctEng is a user form. When I click on the button I am taken
into the VB editor and the line usrSlctEng.show is highlighted in
yellow. When I click the play button on the standard tool bar my form
shows as normal.

Now this happens with any form, any macro, and button and any
worksheet. but only occurs with the line <formname.show. I have been
working on this workbook for two weeks and it has only started happening
this afternoon. Also i have cleared all breakpoints.

Can anyone suggest anything that might fix this problem?

Cheers
Chris


--
rooch84
------------------------------------------------------------------------
rooch84's Profile:
http://www.excelforum.com/member.php...o&userid=26996
View this thread: http://www.excelforum.com/showthread...hreadid=402008