Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default inserting break in code

How do I insert a break into code so that I can troubleshoot code that
occurs upon opening a file?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default inserting break in code

Add the single word:
Stop

near where you want to stop the code.

(Leave the project unprotected.)

papa jonah wrote:

How do I insert a break into code so that I can troubleshoot code that
occurs upon opening a file?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default inserting break in code

Or just go to your code and hit F8 to step through it???

papa jonah wrote:

How do I insert a break into code so that I can troubleshoot code that
occurs upon opening a file?


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default inserting break in code

Position your cursor where you want the break, then click Debug/Toggle
Breakpoint, hit F9, or just left click in the gray column to the left of your
code.

"papa jonah" wrote:

How do I insert a break into code so that I can troubleshoot code that
occurs upon opening a file?


  #5   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default inserting break in code

Sorry - you said code that runs when you open a file. You'll need to refer
back to Dave's advice. You can still step through (F8) an event handler.

"papa jonah" wrote:

How do I insert a break into code so that I can troubleshoot code that
occurs upon opening a file?


Reply
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
INSERTING ROWS IMMEDIATELY AFTER PAGE BREAK YESHWANT JOSHI[_2_] Excel Discussion (Misc queries) 0 July 23rd 09 07:35 PM
Inserting page break da Excel Discussion (Misc queries) 3 May 29th 09 10:37 PM
Inserting header @ page break Esrei Excel Discussion (Misc queries) 1 August 12th 05 01:36 PM
Keyboard Shortcut for Inserting a Page Break Tandy Excel Discussion (Misc queries) 6 July 12th 05 09:35 PM
Inserting rows before page break Robert Christie[_3_] Excel Programming 5 December 15th 03 05:24 AM


All times are GMT +1. The time now is 12:18 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"