User Form properties
Posted on 2012-09-21
I have a file with a simple User Form with a Single button for running a routine. The routine can be triggered from either of two input sheets.
I have chosen to use a User Form and have it set with ShowModal = False so that it is visible on all sheets where required with various .Show and .Hide commands on the sheets where required or not required.
I have used a form rather than a button so that as the user navigates down the sheet populating the necessary fields they can then click on the button in the form to process the data rather than having to scroll back up the screen to click the button. With one sheet I could freeze panes and put the button above the freeze line but this is not an option on the other sheet.
This all seems to be working fine except when the process is run (triggered by the button on the form) the necessary update is done and the cursor goes to the required sheet but the UserForm is still active. I have to click into the sheet to get the sheet active rather than the form. Might seem a simple thing but when the user has clicked the form to do the update they will often then just use the direction arrows to move down the sheet to check it. They often do this on my machine and I have a trackball that they don't like so prefer to use the keyboard.
So question is: How can I deactivate the UserForm without hiding it or is there a setting in the UserForm properties that I need to set? I have set ShowModal to false so that I can leave the Form shown and I ahve tried the Enable property but if I set that to false the button then doesn't work.