antaeusguy
Board Regular
- Joined
- Mar 8, 2010
- Messages
- 81
When a form button is to be modified, the design mode has to be on.
Is there a way to enable/disable the design mode via macro?
The reason I'm doing this is because I've protect my sheet that allows the user to edit objects (I've a ActiveX ComboBox and I need to allow users to type in).
However, I wish to ensure when the file is opened, the user's Excel's "Design mode" is not turned on (else I'm afraid they might not be able to use the form button on the worksheet because design mode is turned on).
Is there a way to enable/disable the design mode via macro?
The reason I'm doing this is because I've protect my sheet that allows the user to edit objects (I've a ActiveX ComboBox and I need to allow users to type in).
However, I wish to ensure when the file is opened, the user's Excel's "Design mode" is not turned on (else I'm afraid they might not be able to use the form button on the worksheet because design mode is turned on).
