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: 119
Default Entering Debug after delete sheet

I have a macro where it's tasks is to delete a WS and copy a replacement from
another WB. When single stepping through the code, after the
Sheets("Lists").delete, VBA will no longer allow me to enter the debug mode.
I get the message "Can't enter debug mode at this time."

Any ideas why this occurs? And how to I enter debug in this code? (other
than debug.print)

In order for the rest of the code to operate correctly, the sheet must be
deleted.

Thanks,
John
 
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
Delete sheet on a condition: debug error [email protected] Excel Programming 3 November 13th 07 09:09 PM
UDF Works in Debug Window but not on Sheet? Andibevan Excel Programming 2 September 26th 06 11:42 AM
PLEASE HELP! Copy sheet with password protected cells debug error bsnapool[_6_] Excel Programming 4 July 10th 06 11:58 AM
entering data to overwrite and delete duplicates marshall Excel Discussion (Misc queries) 3 February 22nd 06 11:55 AM
debug message pops up when I select a range of cells and delete Brian Excel Programming 6 October 17th 04 12:55 AM


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