Hi all,
I have searched Google throughout and found similar but not problems.
Version: Excel 2010
I created a spreadsheet with macros and ActiveX buttons on the page that call these macros. I also have an ActiveX Textbox in the sheet as well. Up until a few days ago, everything was working fine. Now when I open the spreadsheet, all of the ActiveX controls have disappeared and the "Insert" button to add ActiveX & Form controls in the Developer tab is greyed out?? Also, I have some cells with Data Validation on them using a list and I cannot see or get a drop down list to appear (even with Alt + Down). Also, when I enter a value that is in the data validation list, it says that the data I've entered is invalid. Something bizarre is happening..
Does anyone know what's going on here? I believe that the controls are all still there, just being blocked by something (I don't think it's the visibility property - this wouldn't affect the Insert button!) PS. I have enabled macros when the macro security thing pops up when you open the sheet and I can still run macros.
Thanks in advance!
Nick
Bookmarks