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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top