Hi, I have a setup of two workbooks (WB1 & WB2) where WB1 contains my UserForm and WB2 contains the master data.
As it stands, when you open WB1 it automatically loads the UserForm using the below code, however, I would like to option of using a command button in WB2 to change the UserForm shown in WB1 from UserForm to UserForm2. UserForm2 is basically an 'Under Maintenance' page asking users to come back later. I would then have a second command button to do the reverse once maintenance is complete.
Is this possible?
Thanks in advance,
Glynn
As it stands, when you open WB1 it automatically loads the UserForm using the below code, however, I would like to option of using a command button in WB2 to change the UserForm shown in WB1 from UserForm to UserForm2. UserForm2 is basically an 'Under Maintenance' page asking users to come back later. I would then have a second command button to do the reverse once maintenance is complete.
Is this possible?
Thanks in advance,
Glynn
Code:
Private Sub Workbook_Open()
Application.WindowState = xlMinimized 'user cannot see what is entered in Excel
UserForm.Show
End Sub