ginger_jester
New Member
- Joined
- Feb 24, 2010
- Messages
- 1
Hey guys (and gals)
I'm writing a simple excel sheet to help my department keep track of work load.
I've got a worksheet with a cell where you input your user name (which has been validated so that you can only enter a valid user name into that cell.)
I have a "log in" button with a macro attached with takes the user to the "home" worksheet. Unfortunatly I'm pretty useless with excel so the macro will "log you in" regardless or wheather there is a user name in this cell or not.
What I want to know is if there is a way to set up a macro so that it will only run if there is data in this perticular cell (B6) so that you can only log in if you know a valid user name.
It would be nice if when you try to log in without a user name the program prompts you for one.
Thanks a lot everyone!
I'm writing a simple excel sheet to help my department keep track of work load.
I've got a worksheet with a cell where you input your user name (which has been validated so that you can only enter a valid user name into that cell.)
I have a "log in" button with a macro attached with takes the user to the "home" worksheet. Unfortunatly I'm pretty useless with excel so the macro will "log you in" regardless or wheather there is a user name in this cell or not.
What I want to know is if there is a way to set up a macro so that it will only run if there is data in this perticular cell (B6) so that you can only log in if you know a valid user name.
It would be nice if when you try to log in without a user name the program prompts you for one.
Thanks a lot everyone!