Data Validation Greyed out

  • Thread starter Thread starter jcm1229
  • Start date Start date
Do you have more than one worksheet selected?
(Look in the title bar for [Group]. If you see it, rightclick on any worksheet
tab in the grouped sheets and select Ungroup Sheets.
 
Also, you can't change the validation if the workbook is shared.


Dave Peterson said:
Do you have more than one worksheet selected?
(Look in the title bar for [Group]. If you see it, rightclick on any
worksheet
tab in the grouped sheets and select Ungroup Sheets.


The spreadsheet is not protected.

--
jcm1229
------------------------------------------------------------------------
jcm1229's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=14845
View this thread:
http://www.excelforum.com/showthread.php?threadid=264794
 
Back
Top