I have produced a spreadsheet that contains hundreds of checkboxes.
I copied and pasted them as I needed them from the original check boxes
I started with.
It appears that they have multiplied themselves on top of each other
and I cannot just delete them without having to do it to each one
individually which will take me forever.

Any help out there before I lose it?

Thanks


--
danc
------------------------------------------------------------------------
danc's Profile: http://www.excelforum.com/member.php...o&userid=31339
View this thread: http://www.excelforum.com/showthread...hreadid=510238

Hi!

One way if the ckbxs are the only objects you have on the sheet:

Hit function key F5
SpecialObjects
OK
EditClearAll

Biff

"danc" wrote in message
...

I have produced a spreadsheet that contains hundreds of checkboxes.
I copied and pasted them as I needed them from the original check boxes
I started with.
It appears that they have multiplied themselves on top of each other
and I cannot just delete them without having to do it to each one
individually which will take me forever.

Any help out there before I lose it?

Thanks


--
danc
------------------------------------------------------------------------
danc's Profile:
http://www.excelforum.com/member.php...o&userid=31339
View this thread: http://www.excelforum.com/showthread...hreadid=510238

Hi
The F5 key on Excel 200 is for "Go To".
Not sure what you meant.


--
danc
------------------------------------------------------------------------
danc's Profile: http://www.excelforum.com/member.php...o&userid=31339
View this thread: http://www.excelforum.com/showthread...hreadid=510238

Yes, and one of the options (boxes) is Special.
--
Kevin Vaughn


"danc" wrote:


Hi
The F5 key on Excel 200 is for "Go To".
Not sure what you meant.


--
danc
------------------------------------------------------------------------
danc's Profile: http://www.excelforum.com/member.php...o&userid=31339
View this thread: http://www.excelforum.com/showthread...hreadid=510238

The F5 key on Excel 200 is for "Go To".
Not sure what you meant.

Yes, F5 is "Go To". Checkboxes are called objects, so you want to "Go To"
(select) all objects.

Hit function key F5
Click the Special button on the lower left hand side
From the list that's presented select Objects
Click OK

Now, all the objects (checkboxes) will be selected.

To delete them:

Goto EditClearAll

Biff

"danc" wrote in message
...

Hi
The F5 key on Excel 200 is for "Go To".
Not sure what you meant.


--
danc
------------------------------------------------------------------------
danc's Profile:
http://www.excelforum.com/member.php...o&userid=31339
View this thread: http://www.excelforum.com/showthread...hreadid=510238

:) Thanks , the flashing check boxes are gone.
Much appreciated.
Dan


--
danc
------------------------------------------------------------------------
danc's Profile: http://www.excelforum.com/member.php...o&userid=31339
View this thread: http://www.excelforum.com/showthread...hreadid=510238