Keep Application hidden when Userform and Workbook gets closed

**knineistheboss** · 08-01-2014, 10:55 AM

Hi,

I have created a Userform and I use Application.Visible = False (also tried Application.Left = -999). I ask for the Application to become visible with Before_Close event. The problem is that the Workbook stays opened (in the toolbar). If you then try to close it, it asks to SAVE CHANGES (even if I added the code Application.DisplayAlers = False) and the hidden worksheet becomes visible to users. Since the information in the back is confidential, I have to make sure it always stays hidden. I'm getting pretty frustrated since I can't find an answer anywhere. Does anyone have a solution for me?

Thanks in advance!

See attached file.

**mongoose36** · 08-02-2014, 06:09 PM

Try this PAYOUT.xlsm

I took he liberty of editing your UserForm code to add an option of allowing you the administrator to edit the sheet.

To do so type "admin" where the userform requests the employee number and the workbook becomes visible again.

One thing I noticed was that the employee number box only allows a maximum of 7 digits but all your employee numbers are 8 digits.

Let me know if you have any questions.

Keep Application hidden when Userform and Workbook gets closed

LinkBack

Thread Tools

Rate This Thread

Display

Keep Application hidden when Userform and Workbook gets closed

Re: Keep Application hidden when Userform and Workbook gets closed

Thread Information

Users Browsing this Thread

Similar Threads

Worksheets are not protected when workbook is closed via Application.OnTime Method

[SOLVED] Close application if last workbook is closed

Hidden Userform shows instead of Worksheet after Application.Goto

Getting Data from closed workbook into userform

Closing Hidden Workbook when Active Workbook is Closed

Bookmarks

Bookmarks

Posting Permissions