ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hiding a workbook (https://www.excelbanter.com/excel-programming/342386-hiding-workbook.html)

JT

hiding a workbook
 
I have a macro that opens a "security" workbook. On one sheet in the
"security" workbook is 5 IDs and Passwords.

Before the macro can execute other sections of the code, it opens this
workbook and checks the passwords and IDs. It if finds an existing ID and
password, then it continues executing the code otherwise I display a message
that the User is not authorized to use this feature. (Users have to key
their ID and Password) when they kick off the macro.

I can (1) open the "security" workbook, (2) hide the sheet with the IDs and
passwords, (3) compare the user's ID and password, and (4) close the security
workbook.

I have 2 issues:

(1) when I close the workbook, I would also like to close Excel. How can I
do this? Currently the application is open but the workbook is closed.

(2) Is there a way that I can do this, where the user doesn't see the
workbook or Excel is open?

Thanks for the help........


--
JT

bigwheel

hiding a workbook
 
(1) Application.Quit

(2) None that I can think of. Even if running minimised there will be
evidence in the taskbar.


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com