View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JVS JVS is offline
external usenet poster
 
Posts: 5
Default How to lock the path to a macro

Is there a work around or an alternate solution?
I have a time sheet workbook that I am about to issue to approx 200
associates.
I'd like to issue it with no macro's, but was hoping to use a command button
to link to a second "master book" that would contain the macros required to
fix what the users mess up.

Any help would be greatly appreciated!
Thanks!
Johnny

"BrianB" wrote in message
om...
No. "It is a feature, not a bug." <<grin

Regards
BrianB
==============================================


"JVS" wrote in message

...
Can someone tell me how I can lock the path to a macro that I assigned

to a
command button?

Every time I copy the spread sheet from the server to my hard drive the

path
to the macro is changed

to match the location of the work book.

Using Excel 2000.



Thanks!
Johnny