Hi,
I am new to the world of macros. Have recorded a macro in a new DOT file & assigned to a toolbar button. Works OK on my PC, but doesn’t on any other. I stored the macro IN the new DOT file, so how come anyone who uses this DOT file can’t seem to execute the macro.
The error says that there is a wrong macro security setting, or the macro is missing. I have lowered the macro security setting, but the error persists.
I think the answer is that I need to specify in the VBA the filepath of the DOT file, which is a share on the server.
If you think so, what is the precise syntax in VBA for specifying the file path?
TIA,
m.q.