Hello. I am developing a .XLSM dashboard for a company in my PC (I'm a freelancer). I finished the dashboard and I've seen it running in different PCs, even in Excel 2011 (Mac). But when the administrator of the server put the file in a server location, open it (remotely) and try to interact with any of controls on the dashboard (any checkbox, combobox, etc.), we get the message:
"cannot run the macro '...' may not be available in this workbook or all macros may be disabled"
Put in the ellipsis the name of the macro associated with the specific control on the dashboard that I tried to interact with.
I already checked the security settings of the Excel version installed on the server (Excel 2010 by the way) and ENABLE ALL MACROS, even the "Trust access to the VBA project object model". The server administrator reinstalled Excel on the server making sure of installing VBA for applications. After all this, we still get the same error message.
Any help, PLEASE!!!
THANKS
J. Obando
"cannot run the macro '...' may not be available in this workbook or all macros may be disabled"
Put in the ellipsis the name of the macro associated with the specific control on the dashboard that I tried to interact with.
I already checked the security settings of the Excel version installed on the server (Excel 2010 by the way) and ENABLE ALL MACROS, even the "Trust access to the VBA project object model". The server administrator reinstalled Excel on the server making sure of installing VBA for applications. After all this, we still get the same error message.
Any help, PLEASE!!!
THANKS
J. Obando
