VBA to Restrict certain usernames.

[realrookie]

Hello,

Very (extremely) new to VBA. I have tried and googled a lot for this but cannot seem to get anything to work remotely close to what I want (if it is possible).

At work we use a shared workbook for logging tests we perform during the day. The problem is that not everyone has their own user login (e.g. new starters) and they use accounts that all start with "Tester".

Is there a way to lock out any username that starts with "Tester" to prevent using the workbook via VBA? And without typing in every user's name into a sheet.

I did read another post on this forum

/showthread.php?34919-Solved-Restricting-Access-to-Spreadsheet-by-Network-User-Name-ID

but it didn't make any sense to me of what did what and what goes where

Thank you in advance,

RR