Minimize userform and still edit worksheet.

[ge0rge]

I have a worksheet open to a userform first. I can click on many command buttons all which act as a hyperlink to other ecel spereadsheets. I have code in place that allows me to minimize the userform but I cannot edit the newly opened sheet until I close the userform. How can I accomplish minimizing the userform and edit the newly opened excel sheet?

Here is the code I found here from Leith Ross, for minimizing the user form which does work:

Please Login or Register  to view this content.

[royUK]

You need to set the UserForm's ShowModal property to False in the VB EDitor Properties window

[ge0rge]

Thanks, it worked. Is there any way possible to have the userform minimize when I click on the command button on it? This would be instead of clicking the command button, excel sheet opens, and then I have to go back and minimize the form.

[royUK]

Thanks, it worked. Is there any way possible to have the userform minimize when I click on the command button on it? This would be instead of clicking the command button, excel sheet opens, and then I have to go back and minimize the form.

Do you mean a commandbutton actually on the Form itself not the minimize icon? Maybe

Please Login or Register  to view this content.