Toolbar referencing Macors by full path

[MarkB_2]

Hi,

I've created a new toolbar, put some lovely buttons on it, and linked them through to embedded macros - works a treat. I've uploaded this to a file server, but the problem is that the Corporation's enterprise security model prevents the macros running for all users. i need to be able to link the toolbar objects to macros in a file on another server.

Can anyone help with linking a customised toolbar to macros in another file?

 

[pbornemeier]

I believe this will reference the other workbook, but if the security settings prevent running macros in a local workbook, they will likely prevent it running one in a remote workbook as well.

.OnAction = "\\Server\Path\[File Name.xls]!MacroName"