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.