View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_2_] Dave Peterson[_2_] is offline
external usenet poster
 
Posts: 420
Default Sticky filepaths at Assign Macro step

I don't think so.

You could write a macro that would reassign the macros, but before you do that,
check your other post. I think that solution is easier.

On 02/09/2011 12:48, Hunter O'Connell wrote:
When I assign a macro to a tool, the filepath appears to be relative,
i.e. '[filename]'![macroname].

When I move the file or e-mail it, it will read '[driveletter]\
[foldername]\[filename]'![macroname].

Is there code to make the filepath remain relative, as in the first
example above?


--
Dave Peterson