TM1 Forum

Hi,

I have a websheet under tm1 application. It run normally through TM1 web. However, I open in through Excel in TM1 server.
I found that the worksheet containing a "blank" button (but there is a caption through tm1 web). Also, I am unable to edit the button that there is no menu after i right-click mouse button on the button.

On the other hand, there are two buttons which can be edited through right-click mouse button.

What happen on the button? How can it resolve it?

** there is a sub-menu "TM1" in the Excel.
** there is a tm1p.xla related to TM1, any other TM1 configure file missing about my case?

If you switch the Control Toolbox toolbar on in Excel and then activate the Design Mode, are you then able to pick that button, right click on it etc? Whatever the reason, maybe the easiest way is to delete the Action Button and create a new one in its place?

Hi qml,

I want to know the "coding" of the button. It is impossible for me to delete it because I will lose the coding (in the button).

Did you follow my other suggestion and check how the button behaves in the Design Mode?

Hi qml,

Sorry, I don't know how to change design mode. Would you mind to give me step by step?

plkkw wrote:Sorry, I don't know how to change design mode. Would you mind to give me step by step?

I'm not QML but it's before 5am over that side of the world so I'll have to do.

Since you're on Excel 2003...
(a) Right click on a blank area of your toolbars to bring up the toolbar list. Select Control Toolbox from that list: (b) Click on the Design Mode icon to enter design mode: That allows you to edit ActiveX controls, as opposed to the old MS Forms controls that you get on the older Forms toolbar.

Hi Alan Kirk,

Many thanks.