palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
I have the following code to display my userform when the workbook opens ...
Private Sub Workbook_Open()
UserForm2.Show
End Sub
It used to open, as expected, when the workbook opened, but has recently stopped doing that since I switched the userform to 'ShowModal ... False' in the Properties Window.
I definitely need to have the ability to move the userform around the screen, PLUS, the ability to click on the various worksheet tabs without closing down the userform to do so.
Is there a different way I can still have the ability to switch worksheets without closing the userform, and the userform to still be able to appear upon opening the workbook ?
Kind regards,
Chris
Private Sub Workbook_Open()
UserForm2.Show
End Sub
It used to open, as expected, when the workbook opened, but has recently stopped doing that since I switched the userform to 'ShowModal ... False' in the Properties Window.
I definitely need to have the ability to move the userform around the screen, PLUS, the ability to click on the various worksheet tabs without closing down the userform to do so.
Is there a different way I can still have the ability to switch worksheets without closing the userform, and the userform to still be able to appear upon opening the workbook ?
Kind regards,
Chris