Macros Not Executing on Other Client PCs

[Joe Cletcher]

I have developed a couple of Macros executed from the pop-
up menu after right-clicking on a shape. These macros are
stored in a custom shape template. One macro is called
with the following syntax:

=CALLTHIS("JIMO.JimoVBAUtilities.ShowCustomData","JIMO")

The macros are located in a custom shape file
named "JIMO.vss" in a module entitled "JimoVBAUtilities"
in "JIMO.vss". The macro specified in the syntax above is
called "ShowCustomData" and the "CALLTHIS" Visio function
returns the Visio.Shape object for the shape which was
right-clicked as an argument in the macro.

The Visio drawing file, custom shape file, and an Access
database are all copied to an area on our file server.
The macros work fine for me on the file server shared
area.

This syntax works fine for me on my PC at work, the file
server shared area at work and at home (two different
usernames and passwords for home and work). However, the
macro is not executing on other peoples' PCs at work--
neither from the shared file server area nor from copies
on their client PCs.

Any ideas? The client PCs have enabled macros for these
files.

 

[Reinier Post]

Joe Cletcher wrote:

[...]

=CALLTHIS("JIMO.JimoVBAUtilities.ShowCustomData","JIMO")
[...]

This syntax works fine for me on my PC at work, the file
server shared area at work and at home (two different
usernames and passwords for home and work). However, the
macro is not executing on other peoples' PCs at work--
neither from the shared file server area nor from copies
on their client PCs.

Any ideas? The client PCs have enabled macros for these
files.

Is the stencil open on their machines at the moment the CALLTHIS
is activated? It may be opened automatically on your machine
(e.g. if your draing has a code reference to it) but not on theirs
(e.g. because the code reference uses an absolute path to the
stencil and the absolute path is different on their systems).

This might be a possible cause, just guessing really ...