Hi there,
I need some help on changing for example the location of a specific workbook element by using a macro. What I want to achieve, is that a button moves dynamically to the last entry of a list. The list is created by another macro, so it should be no problem, to read the height of every line, sum it up, and set that value as the new location of the button. The reason is, I want to unlock the cells if a user needs to enter a new line and pass on some formulas in some hidden colums.
I am relativley new to php-coding but tried almost every combination of the Macro Engine API found in the manual from pages 96-101.
For example:
Activesheet()->elements()-count(); -> works, for every button I add it increments the number, but I was unable to focus the button itself, neither to read or set any property of the button.
Maybe someone knows what specific line of code is needed to retrieve the position of a button, checkbox or combobox. The "id" of the button in the source code, seems to be calculated dynamically, so i was unable to do something like getElementbyId().
I found one very interessting postdescribing to use hyperlinks for similar issues as a workarround, but maybe someone knows how to do it by manipulating the properties of the workbook elements itself.
Thanks in advance for every hint.
Greets, Peter.
I need some help on changing for example the location of a specific workbook element by using a macro. What I want to achieve, is that a button moves dynamically to the last entry of a list. The list is created by another macro, so it should be no problem, to read the height of every line, sum it up, and set that value as the new location of the button. The reason is, I want to unlock the cells if a user needs to enter a new line and pass on some formulas in some hidden colums.
I am relativley new to php-coding but tried almost every combination of the Macro Engine API found in the manual from pages 96-101.
For example:
Activesheet()->elements()-count(); -> works, for every button I add it increments the number, but I was unable to focus the button itself, neither to read or set any property of the button.
Maybe someone knows what specific line of code is needed to retrieve the position of a button, checkbox or combobox. The "id" of the button in the source code, seems to be calculated dynamically, so i was unable to do something like getElementbyId().
I found one very interessting postdescribing to use hyperlinks for similar issues as a workarround, but maybe someone knows how to do it by manipulating the properties of the workbook elements itself.
Thanks in advance for every hint.
Greets, Peter.