ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Log-in Screen (https://www.excelbanter.com/excel-programming/381456-log-screen.html)

Lifestyle

Log-in Screen
 
I would like to create a splash screen when my workbook first opens and
all worksheet tabs are hidden by default. From there I would like to
create a log-in screen (with user name and password) and depending on
the user name, once entered it unhides only a selected worksheet or two
depending on who the user is.

i.e. If I log in as Admin ... then all worksheets will be displayed
i.e. If I log in as John ... only worksheet 2 is displayed etc etc
i.e. If I click cancel or don't enter a user name then Excel should exit

Hope someone can help me.


All times are GMT +1. The time now is 05:32 AM.

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