Macro to auto shut down workbook

[Dibbley247]

Hi

is there a way to automatically shut down the workbook with a macro, but it would need to use some sort of lookup.

Sheet1 A1 would have the application user name (I already have this macro)

Column B would have the list of names that can use the workbook

if the name in A1 does not match whats in the list, the workbook would shutdown, else it stays open.

Passwords in this place lasts a week before having to change them again, so this is the only way to keep unwanted people out.

Thanks

[Sean Thomas]

if you have a button that the user clicks to check details & then enter workbook,
then use a lookup procedure to check the name exists.
if it exists then enter work book.
if not then call this macro

Please Login or Register  to view this content.

[HaHoBe]

Hi, Dibbley247,

as

Please Login or Register  to view this content.

may be changed by each user IŽd recommend to rely on

Please Login or Register  to view this content.

which is the name unbder which the user is logged-in into the computer.

Instead of using VLookUp you could use CountIf. And you may either make it all capitals or lowercase for comparision.

Use the Workbook_Open-event in ThisWorkbook for starting an automatic check when macros are enabled.

Ciao,
Holger

[dgwebster]

in the workbook.open event

Please Login or Register  to view this content.

this will return the row number it finds the match in to the variable, if no match is found the error causes it to jump to the exit.



Sent from my HTC One_M8 using Tapatalk

[Dibbley247]

Looks like what i need! I'll just change the workbook saved to FALSE as i wouldn't want it saved (But then if changes wasn't made, it wouldn't matter)
But after discussion, it now looks like a different method is needed.

Same setup, but:
Checks the list of names, if it's there then open it (like what you have) else open as read only? Could this be done?

Thanks