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: 92
Default OnTime code error "can't execute code in break mode"

Hi,
Please give advice why I get error.

When I step into RunInvComment code, it first mark first line but
doesn't trigger "ShowComment". Then it mark second line and show error
"You can't execute code in break mode". Of cource I when I started to
step into this, it was_not_break_mode.

Sub RunInvComment()
Application.OnTime Now + TimeValue("00:00:00"), "ShowComment"
Application.OnTime Now + TimeValue("00:00:03"), "Deletecomment"
End Sub

Sub Deletecomment()
Selection.ClearComments
End Sub

Sub ShowComment()
Selection.AddComment "This is a 3 sec Comment !"
Selection.Comment.Visible = True
End Sub

Kind reagrds
tskogstrom

 
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
What does this mean? "Can't execute code in design mode" Danni2004 Excel Discussion (Misc queries) 4 September 27th 07 11:22 PM
"Can't enter break mode at this time" Paul T. Excel Programming 5 August 25th 06 10:57 PM
"File Format Not Valid" When Starting Excel. Error Code 0D3F6000 EMT_Hawk Excel Discussion (Misc queries) 4 March 31st 06 09:22 PM
"CAN'T EXECUTE CODE IN BREAK MODE" Chuckles123[_72_] Excel Programming 2 November 22nd 04 05:06 AM


All times are GMT +1. The time now is 04:05 AM.

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

About Us

"It's about Microsoft Excel"