ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent typing in a drop-down list to run macro (https://www.excelbanter.com/excel-programming/373149-prevent-typing-drop-down-list-run-macro.html)

MacroMan[_5_]

Prevent typing in a drop-down list to run macro
 
I have a locked and protected worksheet (& workbook) that uses
drop-down lists (not locked nor protected) with the source data located
on another hidden worksheet. I must have the spreadsheet check each
user entry from the drop-down list once it is entered, and then run a
macro after each change. The problem is that the workbook event of
"SheetChange" (or "SheetCalculate") won't work if the user types the
exact same available entry as in the drop-down list. The macro will
only run when the user selects from the drop-down list only.

Any help would be appreciated!



All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com