One more thing...this is saved as an Excel Template which the user
will open to enter data and then it will do a number of calculations.
It is saved as VancoKinetics7.XLT. This works fine if I right click
the icon and OPEN it. However, I want them to just click the icon,
which opens a NEW file. When I do this the Sub Test() you suggested
doesn't work. It doesn't give me a Path, the Name is VancoKinetics71,
and the FullName is VancoKinetics71 (same as the name, without a
Path). Since there is no Path in the FullName, it will run no matter
where it is opened from. In Word there is difference between
Document_New and Document_Open. In Excel there is only a
Workbook_Open choice (no WorkBook_New). Does this make a difference
in how the workbook is started (New vs Open)? If so, how do I verify
that it is only running on the specified network path if they just
click the icon and open a NEW workbook? I don't want someone to copy
this template to, say, a flashdrive and install it somewhere else.