Here I go again, I was thinking of removing the website access code from this point and use a UserForm that is more flexible and can give me more options, JPG and beautiful colors.
The reason for change is that the website access was for registering and with the current approach the client has only one opportunity to register and if client has no internet connection they’ll be no opportunity.
So I thought by removing the code to access a website, I would just let code run its course as it is.
So what I’m trying to figure out is how to have this same UserForm , let’s call it UserForm2, open first upon opening of workbook before UserForm1, but once client has selected the register now button or cancel on UserForm2 then this userform will not reappear anymore and only UserForm1 will appear.
Here is the code I am using in My Workbook Module at the present moment; I figure that’s where the change must be made.
Code: Select all
Option Explicit
Private Sub workbook_open()
If Sheets("Sheet1").Range("A1") = "Password" Then
UserForm1.Show 'Is used as main opening page for navagation
Dim wsh As Worksheet
For Each wsh In Worksheets
wsh.Protect DrawingObjects:=False, Contents:=True, Scenarios:=True, _
PassWord:="", UserInterfaceOnly:=True
Next wsh
ActiveWorkbook.Protect PassWord:="", Structure:=True, Windows:=True
Exit Sub
End If
'Activation UserForm used for username and password
Activation.Show
End Sub