| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Paste in VBA
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range Paste in VBA
Unless you move the data to the workbook and link the comboboxes to the
local range, there would be no command for that. -- Regards, Tom Ogilvy "Tobie Hanekom" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy range and paste into every 3rd cell of new range | New Users to Excel | |||
| Prevent cut and paste over a range | Excel Worksheet Functions | |||
| how do I paste range name list? | Excel Worksheet Functions | |||
| Paste a named range to another range in Excel | Excel Discussion (Misc queries) | |||
| how do i paste a range? | Excel Programming | |||
Hybrid Mode
