Command Button Macro Link Broken

[PumaMan]

Hello,

I have a 07 Excel file that has some command buttons that call very simple Macros on click. This sheet is accessible through an intranet site and functions with no problems for 07 users. Whenever someone with Excel 03 accesses the file, it converts it and opens the file up in Excel instead of the web browser. That's perfectly fine with me and what I want to happen.

However, when those 03 users then click the command button, the link to the Macro is broken for some reason. The user received a "#ref' cannot be found" error. This used to work with no problems, so I'm at a loss as to why it's happening now.

Misc Info: The sheet has 9 tabs and these buttons reside on tab #7. I looked at the VBA project model and the macros are stored in Module #7.

I've tried so many things, but can't figure it out. I appreciate any help. Let me know if I can provide anything additional to help.

Desperately yours,
John

 

[PumaMan]

well no it doesn't let me assign it to the active x control like the command button does. I just added the vba code to the button-click event.

 

[xenou]

Okay (I wasn't sure if that was even possible or not). I'm stumped, but I've never used excel on sharepoint. Might be a security feature?

 

[PumaMan]

Maybe. I'll see if the issue happens when the user accesses the file from a location outside of SharePoint. I truly appreciate the help.