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

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