Sage MAS Intelligence

[MAS90Ninja]

Everything seems to work fine until I get to the final menu to actually view the finished report.  The cursor becomes a fat cross and none of the buttons to execute the financial statements can be selected.

I have tried "enabling" macros, and this didnt help.

So far, Sage support does not know and they are trying to contact someone in South Africa. 

Any ideas????

Thanks!

[accountingnerd]

It sounds to me like Excel is in design mode. If you are in Excel 2010, enable the developer tab (if it isn't already enabled) through File > Excel Options > Customize Ribbon. I think the path is similar for 2007, but I don't have a copy handy. Check the status of the "Design Mode" button. If it's highlighted, click it to turn it off, and you should be good to go.

If that's not it, let us know.

[MAS90Ninja]

Design mode is grayed out. We are using Excel 2007.

[accountingnerd]

MAS90Ninja -- Can you run the macro manually? I don't know if you're an Excel Ninja, too, so don't be offended if you already know how to do this.

1) Alt + F11 brings up the VBA window

2) In the project screen (usually top left), double click on "Sheet8(MENU)" to show the code for that sheet.

3) Place your cursor on the line after the line that says "Private Sub cmdLayout1I_Click()", and then press F5.

The macro should run, assuming that you really do have macros enabled, and it should let you generate a layout. Let me know the results.

[MAS90Ninja]

Thank you sensei for your prompt reply.  I am not an Excel ninja, but I have done some research.

I have discovered that the macros and the Visual Basic features are disabled.  I tried top enable using security and this was no help.  Using the Excel help menu I discovered that these features will be disabled if the digital certificate is invalid or expired.  In the developer, Macro Security, Trusted Publisgers, I noted the Alchemex digital certificate expired March 2011. My guess is this could be the issue.  How do I get an updated digital certificate from Alchemex? I will call Sage again tomorrow. 

[accountingnerd]

The digital signature is from the executable file... If the certificate expired, I wonder why the rest of us aren't having this issue? <perplexed>

[MAS90Ninja]

I discovered the expired didgital certificate isn't the issue.  The other macro security settings (liberal) override the use of the certificate. So I'm not even sure why there is a certificate if it is not used.

Part of the issue is the macros and VB execution was not active.  Solved this by having Excel uninstalled and then re-installed.  However I'm still having the same issue... unable to execute the macro from the menu tab. Getting closer to a solution by process of elimination (I hope).

[MAS90Ninja]

When I double click on Sheet8(menu) the window opens on the right.... and there is NO code.

[accountingnerd]

No code? Now I'm really perplexed. Can you upload the template file?

[MAS90Ninja · Accepted solution]

Great news.  The issue has been resolved.  After re-installing Excel (and OTHER MS Office features), I deleted the report, created a new copy, re-generated the template.  It worked perfectly.  For future reference the issue was this:

The client has hosted MAs and SMI.  I asked the host provider to install Excel 2007, which they did. Turns out, only Excel 2007 was originally installed, which is what I asked for.  However,  Office Shared Features and Visual Basic for Applications are also required to be installed or the SMI software doesn’t function.  These features are usually installed by default when the entire Office suite is installed.  Once those featires were installed and I re-generated the template all worked fine.

Thank yo for your suggestions, they helped troubleshoot this issue.