View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
BOBODD BOBODD is offline
external usenet poster
 
Posts: 26
Default Delete all Macros Error

Hi Chip,

I hope you're still monitoring this thread. I've stepped through my code
which behaves as I want, but once I reach the first line of the For Each loop
to delete the code - (Set VBComps = ActiveWorkbook.VBProject.VBComponents) -
I get the error "Can't enter break mode at this time."

This still appears to only delete some of the code from my project. As this
code is deleting itself, is it possible that this is being deleted before
looping through every component? If so, can I affect the order that this code
loops through each control?

Thanks for your help on this.

"Chip Pearson" wrote:

Sorry Chip, I'm still new to the debugging part of this.


You can find a good explanation of various debugging techniques at:
http://www.cpearson.com/excel/Debug.htm





"BOBODD" wrote in message
...
Sorry Chip, I'm still new to the debugging part of this. Will repost if I
still can't find the problem over the weekend :-)

"Chip Pearson" wrote:

You need to narrow down the code only to the relevant block of code. You
can't really expect someone to attempt to replicate your workbook,
worksheets, forms, and so on.