macros in financial reporter template

[johnhugh]

Hi,

I'm using Accpac 5.5

I've written a FR Excel 2003 template and added some macros to it which are run after the report has been generated.

The macro survive the report generation and work well.
I also added a button on the template so the macro can be easily run from it. However the button does not come through the report generation stage. On the finshed report it disapeared.

I know I've done it before and the button was show on the finished report but can't get it to work anymore.

Any suggestions?

 

[ettienne]

Place the button outside the report spec area.

 

[johnhugh]

I tried that but it won't work.
I placed it into the actual print area now and this seems to be working.

 

[johnhugh]

Is it also possible to get a 2nd sheet or maybe a hidden sheet through the financial reporter?

If I have a hidden sheet in my template can this somehow be shown in my finished report?

 

[ettienne]

No, FR only works with the current worksheet.

 

[johnhugh]

Thank you.