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.
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.