Thread: Command Button on Protected Form
2014-08-20, 22:15 #1
- Join Date
- Aug 2014
- Thanked 2 Times in 2 Posts
Command Button on Protected Form
I'm working on a form which has a command button to clear the fields and reset the form. It usually works fine, but sometimes it stops responding to the mouse at all. It doesn't even appear to depress. Unprotecting the document, enabling Design mode, then disabling Design mode and re-protecting the form will get it working again. At least for a while.
I've seen some references to command buttons not working on protected forms, but it does work most of the time, so that's obviously not the case. Can anyone suggest what the issue might be and how I might work around it to ensure the button works every time for the users of the form?
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!