Hi
I have a spreadsheet that I want Team A to be able to input into one set of columns, Team B into another and Team C into a third set of columns
When writing the Macros I have been using the following line at the start of each macro. (list of names is a lot longer)
If Application.UserName <> "Jane Jones" And Application.UserName <> "Bob Smith" Then Exit Sub
Is there a way to have a sheet with the list of team A in column A and team B in column B and team C in column C then have a bit of the macro to say if UserName is not in column A then exit sub otherwise carry on?
My thinking is that this would be a lot easier to change the list of team members when staff come and go rather than running through all the macros to make sure I change each and every one.
I have a spreadsheet that I want Team A to be able to input into one set of columns, Team B into another and Team C into a third set of columns
When writing the Macros I have been using the following line at the start of each macro. (list of names is a lot longer)
If Application.UserName <> "Jane Jones" And Application.UserName <> "Bob Smith" Then Exit Sub
Is there a way to have a sheet with the list of team A in column A and team B in column B and team C in column C then have a bit of the macro to say if UserName is not in column A then exit sub otherwise carry on?
My thinking is that this would be a lot easier to change the list of team members when staff come and go rather than running through all the macros to make sure I change each and every one.