delete multiple "drop down" boxes in an excel spreadsheet

[SFJayhawk]

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?

[Allllen]

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?

[SFJayhawk]

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?

[Allllen]

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?