I am pasting a large amount of data that has a number of underlying drop down
boxes embedded in the data. How can I completely remove these boxes? I do
not care if the data within the boxes is saved. Any help would be much
appreciated! Thanks. Perhaps using VBA?

start by trying this:
select the whole sheet
data validation clear all

if they are really combo boxes or list boxes then this can be done with VBA
but I reckon you won't need it
--
Allllen


"SFJayhawk" wrote:

I am pasting a large amount of data that has a number of underlying drop down
boxes embedded in the data. How can I completely remove these boxes? I do
not care if the data within the boxes is saved. Any help would be much
appreciated! Thanks. Perhaps using VBA?

Looks good. I also have another problem in that I have embedded HTML boxes.
Do you know how to delete all of these at once? The cell =
EMBED("Forms.HTML:Hidden.1",")

Thanks again for your help


"Allllen" wrote:

start by trying this:
select the whole sheet
data validation clear all

if they are really combo boxes or list boxes then this can be done with VBA
but I reckon you won't need it
--
Allllen


"SFJayhawk" wrote:

I am pasting a large amount of data that has a number of underlying drop down
boxes embedded in the data. How can I completely remove these boxes? I do
not care if the data within the boxes is saved. Any help would be much
appreciated! Thanks. Perhaps using VBA?

Post this as a new question in the programming section. You will have to use
a VBA subroutine.
--
Allllen


"SFJayhawk" wrote:

Looks good. I also have another problem in that I have embedded HTML boxes.
Do you know how to delete all of these at once? The cell =
EMBED("Forms.HTML:Hidden.1",")

Thanks again for your help


"Allllen" wrote:

start by trying this:
select the whole sheet
data validation clear all

if they are really combo boxes or list boxes then this can be done with VBA
but I reckon you won't need it
--
Allllen


"SFJayhawk" wrote:

I am pasting a large amount of data that has a number of underlying drop down
boxes embedded in the data. How can I completely remove these boxes? I do
not care if the data within the boxes is saved. Any help would be much
appreciated! Thanks. Perhaps using VBA?