Range Paste in VBA

T

Tobie Hanekom

I am send an email from Excel with success, but the sheet attached to the
mail has objects on it with combo box lists on another sheet. This causes
the sheet attached to the mail being linked to the original workbook.

What code do one use to range paste the sheet which will "delete" the links?

Tobie
 
T

Tom Ogilvy

Unless you move the data to the workbook and link the comboboxes to the
local range, there would be no command for that.
 
Top