View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Larry Fitch Larry Fitch is offline
external usenet poster
 
Posts: 24
Default Yes no drop down list and macros

I have an excel sheet that get imported into another workbook by way of a
macro.. This sheet contains two drop down lists.

When I run the macro I get an info box that pops up telling me:

"A formula or sheet you want to move or copy contains the 'YES_NO' which
already exists on the destination worksheet. Do you want to use this version
of the name?"

Can I add any code to the macro to always say yes to this and not see the
dialogue box ??


--
Thanks

Larry