thanks for all of the help so far. I would rather not save it as
an .XLS and run it from that. We had one previously with the formulas
in the cells. It was always getting corrupted, or someone would save
changes when closing and the workbook  would keep the values they had
input. That could lead to errors if someone wasn't careful and left
an old value somewhere. So I did this to clean up the worksheets, let
the program make the decisions on which formula to use based on user
input, hide the formulas so they could not get corrupted and make
data input easier through UserForms. I would prefer to have it
accessed as an .XLT. So, that seems to leave out the verify pathname
option to prevent it's unauthorized use (outside of our department).
I'm thinking using a roster to match the Excel username against the
roster might be the way to go. Would you recommend adding another
worksheet and list them there or have a separate workbook? I'm new to
this, so I've never pulled the data from another workbook. Either
way, what would be the best way to verify the Excel username against
the roster?