Validation - removal of over an entire spreadsheet
 

MS Excel 2002 SP3
What is the easiest way of clearing multiple validation points off a
work sheet?
I have a spreadsheet with many validation points spread all over.
I wish to use the sheet for other purposes, but rather than recreate
the work sheet, I could remove the validation drop downs.
How can this be done?
Regards
Roger

Validation - removal of over an entire spreadsheet
 

Roger,
There is a "Clear All" button on the Validation Form...
Data | Validation
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Roger"
wrote in message MS Excel 2002 SP3
What is the easiest way of clearing multiple validation points off a
work sheet?
I have a spreadsheet with many validation points spread all over.
I wish to use the sheet for other purposes, but rather than recreate
the work sheet, I could remove the validation drop downs.
How can this be done?
Regards
Roger

Validation - removal of over an entire spreadsheet
 

On Jul 26, 1:35 pm, "Jim Cone" wrote:
Roger,
There is a "Clear All" button on the Validation Form...
Data | Validation
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Roger"
wrote in message MS Excel 2002 SP3
What is the easiest way of clearing multiple validation points off a
work sheet?
I have a spreadsheet with many validation points spread all over.
I wish to use the sheet for other purposes, but rather than recreate
the work sheet, I could remove the validation drop downs.
How can this be done?
Regards
Roger

Gosh.....simple when you know how isn't it....thanks