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