how to delete drop down boxes

[Blaine]

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

 

[covingj]

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.

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP