Have been using a spreadsheet for almost two years that in its current incarnation has developed a unpleasant “feature.” Typically I would open the most recent version; do a File-Save As and change to a new name; update the data and everything would be fine. A single cell on one of the worksheets uses Data Validation (to control the printed or displayed version of the data), and Drop-down List method is used and linked to a SOURCE containing 3 cells (=$B$66:$B$68) on the same sheet.
Problem 1: Suddenly and without warning the Data Validation Drop Down List no longer functions. The Validation itself works. That is, if I try to input (type) something other than what is in the Validation List (=$B$66:$B$68) I get the expected Data Validation Error Message, but the Drop Down is gone. I have deleted and re-entered the Data Validation a couple of times to see if that worked, but it did not.
Problem 2: So I figure – no big deal – I’ll just change the Data Validation functionality to a ComboBox using the Forms Toolbar. I do the View-Toolbars-Forms thing and the Forms Toolbar is there, but all the buttons are greyed out. After rebooting and trying a bunch of other stuff (including an attempt at creating a new blank workbook and adding a ComboBox to that and then trying to copy/paste it into the problem spreadsheet, waste of time it turns out); I’m stuck.
Searched the posts here and have not had any luck, also checked the MSKB. Thanks in advance for your help.
