Macro to shutdown workbook if name isnt on the list

[Dibbley247]

Hi Guys

I'm having a problem, I can't get the following to work? It highlights the "User" part in blue

Basically, a list of names is in Z
And the username should appear in A1. If the name does not match on the list, it should shutdown.

Thanks

Please Login or Register  to view this content.

[Vikas_Gautam]

Try this..

Please Login or Register  to view this content.

Don't forget to click *

[apo]

Or this maybe..

Please Login or Register  to view this content.

[Jim885]

Hi Guys

I'm having a problem, I can't get the following to work? It highlights the "User" part in blue

Basically, a list of names is in Z
And the username should appear in A1. If the name does not match on the list, it should shutdown.

Thanks

Please Login or Register  to view this content.

About the only thing I found wrong with your original code is, this;

Please Login or Register  to view this content.

should have been this;

Please Login or Register  to view this content.

And add 'End Sub' as the last line.