LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Locking debug mode in a macro Megadrone Excel Worksheet Functions 1 November 30th 06 10:32 PM
Get in DEBUG mode on workbook open Anthony Fok[_2_] Excel Programming 5 July 28th 05 06:30 PM
Don't show sheet switches when running macro Ben Excel Programming 4 May 25th 05 02:10 PM
Debug Step vs Run Mode Arthur[_3_] Excel Programming 3 November 9th 03 05:03 PM
Mysterious debug mode Shunt Excel Programming 0 August 7th 03 02:35 PM


All times are GMT +1. The time now is 01:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"