Copy and Paste Drop Down buttons containing macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to copy and paste a drop-down box containing macros from
one workbook in excel to another? I have tried everything I can think of and
each time I close the original workbook the drop-down box clears in the
workbook I pasted into.

Thanks!
 
What kind of dropdown is it?

You may find the easiest method is to create comboboxes from the control toolbox
toolbar. The code for this combobox will be behind the worksheet that holds the
combobox.

And when you're ready to copy, copy the whole sheet -- not the cells.

rightclick on the sheettab and select "move or copy..."
Point at the new workbook and make sure you check that copy checkbox.

Then if you have to, you can clean up any of the cells you need in that copied
worksheet.

========

But I'm not sure if I understood correctly.

What does "drop-down containing macros" mean?
 
Back
Top