TM1 Forum

hi all,

I have written a VBA code with the intention to run it through a button in an Excel worksheet. However, when the button disappears when the sheet is loaded in TM1 Web.

Anyone knows how to get this working i.e. button showing up? Or TM1 Web simply strips off all VBA and any non-Action buttons?

One simple need is to NOT use an Action Button to recalculate a worksheet as it actually does a RECAL to entire workbook. I just want to do RECAL to one sheet where the button is.

Thanks.

harrytm1 wrote:hi all,

I have written a VBA code with the intention to run it through a button in an Excel worksheet. However, when the button disappears when the sheet is loaded in TM1 Web.

Anyone knows how to get this working i.e. button showing up? Or TM1 Web simply strips off all VBA and any non-Action buttons?

One simple need is to NOT use an Action Button to recalculate a worksheet as it actually does a RECAL to entire workbook. I just want to do RECAL to one sheet where the button is.

I'm not sure about the button (you haven't indicated whether it's a Forms 2.0 type one, or an ActiveX one), but I'm afraid it doesn't matter whether the button is there or not... since Web doesn't let you run VBA. At all.

Alan Kirk wrote:I'm not sure about the button (you haven't indicated whether it's a Forms 2.0 type one, or an ActiveX one), but I'm afraid it doesn't matter whether the button is there or not... since Web doesn't let you run VBA. At all.

Just did a test on this and found that Web (9.1) won't render either type of standard command button, only action buttons. The buttons are still in the sheet (you'll see them if you launch the sheet from the Applications folder in a standard session), but they don't render when the workbook is opened as a websheet.

Either way, still no VBA.