View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nb0512 nb0512 is offline
external usenet poster
 
Posts: 9
Default Message box warns for duplicate use of named ranges when copying s

I created an Exel/VBA2003 application in which a copy of a worksheet is added
when the user pushes some button on the main form. In the worksheet which is
copied, I use a few named ranges. This works fine in 2003.
In 2007, however, a message box pops up that warns for duplicate use of the
named range in the new sheet. Since there are 5 ranges, it is quite annoying
to cancel these message boxes every time.

Can I programmatically prevent these msg boxes from popping up ?

Thanks !