Workbook Visibility

[ewalks]

Hello all:

I am creating a VBA workbook with UserForm to allow users to input data. I do not want the workbook to be visible to the user and have used "application visible=false" code. Everything appears to be working just as I want, however, I do not want to add a button/code the userform to allow visibility of the workbook (this is the only option I was able to find). The idea is that as the developer, I would like to be the only one to have access to the updated workbook. Is there a way for me to do this without making the workbook invisible to me as well? In my test runs, I have had to disable macros to view updates to the workbook. Thanks in advance!

 

[Logit]

.
Here is part of a macro that makes the workbook visible. The command button is located on the user form.

Private Sub CommandButton3_Click()
    TextBox1.Text = ""
    TextBox2.Text = ""
    TextBox3.Text = ""
    UserForm1.Hide
    Application.ScreenUpdating = False
    ThisWorkbook.Application.Visible = True
    ThisWorkbook.Application.WindowState = xlNormal
    Application.ScreenUpdating = True
    UserForm1.Show vbModeless
    Me.TextBox1.SetFocus
End Sub

Obviously, the macro performs other functions as well.

You could make a password window (Inputbox) appear when you click the button, and if the password is correct the workbook is make visible. If the password is incorrect,
you could choose for the workbook to close completely or return the user to the Inputbox again for a second try at the password. There are a number of different options
you can take.

Here is a link to download the project containing the above macro : https://www.amazon.com/clouddrive/share/w3E0yxqHHd0HbFblRLbh9VqwKpjRL0nUzI6XgnlE1s7

 

[ewalks]

Thanks Logit. Fantastic idea, I hadn't thought of password protection. I'll give this a try.

 

[Logit]

You are welcome.