how to delete drop down boxes
 

do not know the version of excel I am working with...I have created a
worksheet with drop down boxes and I cannot put it onto web sites for clients
to use as I am told it is to complicated and i need to simplify it...so I
need to delete the drop down boxes however I cannot find the information to
allow me to do it without redoing the whole thing and not greating the
boxes...

Is there a way to delete the boxes to simplify the worksheet.

To describe the sheet, it is a calender that has 52 sheets for each week of
the year...then 7 days on each sheet...then each day has 5 rooms to be booked
and then 35 time slots per each room and each time slot has a drop down box
so the user only has to select the time box and choose their
name...complicated, I know.

Thanks for any help to save me time.

Blaine

how to delete drop down boxes
 

The drop down boxes are created using data validation. You would have to
remove data validation from each instance. Hopefully someone will be able to
give you a macro to do so.

"Blaine" wrote:

do not know the version of excel I am working with...I have created a
worksheet with drop down boxes and I cannot put it onto web sites for clients
to use as I am told it is to complicated and i need to simplify it...so I
need to delete the drop down boxes however I cannot find the information to
allow me to do it without redoing the whole thing and not greating the
boxes...

Is there a way to delete the boxes to simplify the worksheet.

To describe the sheet, it is a calender that has 52 sheets for each week of
the year...then 7 days on each sheet...then each day has 5 rooms to be booked
and then 35 time slots per each room and each time slot has a drop down box
so the user only has to select the time box and choose their
name...complicated, I know.

Thanks for any help to save me time.

Blaine

how to delete drop down boxes
 

Sub Macro1()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
On Error Resume Next
ws.Cells.SpecialCells(xlCellTypeAllValidation).Del ete
Next ws
End Sub


Gord Dibben MS Excel MVP

On Tue, 23 Feb 2010 08:07:02 -0800, Blaine
wrote:

do not know the version of excel I am working with...I have created a
worksheet with drop down boxes and I cannot put it onto web sites for clients
to use as I am told it is to complicated and i need to simplify it...so I
need to delete the drop down boxes however I cannot find the information to
allow me to do it without redoing the whole thing and not greating the
boxes...

Is there a way to delete the boxes to simplify the worksheet.

To describe the sheet, it is a calender that has 52 sheets for each week of
the year...then 7 days on each sheet...then each day has 5 rooms to be booked
and then 35 time slots per each room and each time slot has a drop down box
so the user only has to select the time box and choose their
name...complicated, I know.

Thanks for any help to save me time.

Blaine