OnAction macro assigment through a macro in network environment behaves strange

I have 2 files in a network drive (Y = \\ganymede\infor\)

1.) I assign (in Macros.xlsm) a macro to a button in the other file (button.xlsm)
2.) I make a hyperlink to the button.xlsm

The Code in Macros.xlsm

Please Login or Register  to view this content.

If I open the button.xlsm
1.) from Explorer, everythings works perfect, the macroassignment is:
Macros.xlsm!Copy and it works, when I push the button

2.) trough the hyperlink, the macroassigment is:
\\ganymede\infor\Temp\Macros.xlsm!Copy
in this case pushing the button, I get an error message: the macro in the file inaccessible or the macros are banned.

I must open my file trough hyperlink (2. case), what do I have to do.

I am working with MS Server 2003, SP2. Excel 2010.

I attached the files, if you want to test it, you have to open Macros.xlsm, and run Test.
Thank you very much for your time and help!

The code (which is a part of a big project I inherited) runs without difficulty in Excel 2003 and I can't avoid this bug (? in 2010).

Please help me!

Give a more accurate error message that you receive for pressing that button. I think that may help the troubleshooting process.

-X

Hí xenith1988, thank you very much for your hint. My Excel isn't English, I had to find the exact message, that is:

The macro may not be available in this workbook or all macros may be disabled.
The Y network place is in the Trusted location

1) This may be a resolution: Remove any underscore in the macro name. Instead of Macro_one use MacroOne. Hopefully this helps.

Or 2) A may be a bug in MS. Add "thisworkbook." before the macro name you are trying to call. Instead of using something like: Application.OnTime Now + TimeValue("00:00:05"), "SluitAf". Use: Application.OnTime Now + TimeValue("00:00:05"), "thisworkbook.SluitAf"

As a last resort I heard this works... "We were experiencing the same issues too. Our resolution at the moment is to copy the users profile, delete it, and then have the user login to the workstation essentially rebuilding the profile. The user is now able to use the macros."

Let me know how this works for you. I am troubleshooting my own end here. (I used to work server environments so it does sound like a profile / roaming profile issue but I'd have to be there and clear minded. I've been up 18 hours on this ... snag of my own. I'll be riggghhhttt here if you need more ideas thrown your way!)

I am no expert but I think it has something to do with the "ActiveWorkbook" function calls. Then again, what do I know. I'm new to this whole thing to, just throwin my perspective out there.

Thank you for your kindness xenith1988, unfortunately none of the hints was successfull.

I am going to try a bunch of off the wall guesses here, one of them might work so you never know. The Temp folder (\\ganymede\infor\Temp\Macro.xlsm!Copy), is this a user made folder or a default folder? Is it an actual temporary folder? Also, is ganymede a user on the server? Or a user on the network? Try putting the file on a folder that's off the root drive and share that folder by giving all appropriate users the right permissions. (This CAN be a permissions or access issue)

Let me know if that helps any.

-X

ganymede is a standalone file server, and every location (including \temp folder) on this server are Trusted Location.
If I change the Y: driver to C: (local driver) everything works perfect.
It means for me, this is in connection with the network.