![]() |
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 |
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