You could use the workbook full filename to make sure it is run from
the network drive

FName = ThisWorkbook.FullName

Thisworkbook is the workbook where the macro is being executed from.
So if you add a test to the macro checking the fullName they won't be
able to run the macro from another location. Yo uprobably need to
protect this portion of the macro becaue somebody who knows VBA could
then modifiy the check.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=180187

Microsoft Office Help