MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Data>Validation Problem

Posted by Paul E on March 29, 2001 11:58 AM

It seems that when I try to apply Data>Validation to a cell contained within an area set to the Freeze Panes command, I cannot invoke the functionality of the Validation command.

I wanted to allow the user to view different elements in the Freeze Panes area (top 6 rows of the spreadsheet) based upon the selection from the Validation cell. I set this area to Freeze Panes so that no matter how far down the user scrolled on the worksheet, they could still see the top 6 rows of information.
Any help would be greatly appreciated. Thanks

Posted by mseyf on March 29, 2001 1:53 PM


I don't think Data Validation works in the 'Frozen Panes' area. you may need to use a Combo Box from the 'Control Toolbox' toolbar.

I think there's been a thread or two about combo boxes the past day or so.


Posted by Paul E, on March 30, 2001 6:34 AM

Thanks for the suggestion Mark