If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Macrobutton to run macro that updates formula
Is there a way to have a macrobutton's display text disappear after it is
double-clicked in the following situation (or ideally just not appear in the printed version): 1. In a template, I have set up a table with 3 rows. 2. The user inserts financial amounts in Row 1 and 2. 3. I have set up Row 3 with a Sum(Above) formula. 4. Next to the formula, I have placed a macrobutton that runs a macro which updates the field (ie. the total of the table). 5. The display text of the macrobutton is 'Calculate'. 6. After a user double-clicks on it and the field is updated, I would like the word 'calculate' to no longer appear (or ideally, to not appear in the printed version). Thank you. |
#2
|
|||
|
|||
Macrobutton to run macro that updates formula
As this is a template, it would be simpler to move the macro control from a
macrobutton field to a floating custom toolbar, saved in the template, with a button to run the macro. Then the problem doesn't arise. http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mgirving wrote: Is there a way to have a macrobutton's display text disappear after it is double-clicked in the following situation (or ideally just not appear in the printed version): 1. In a template, I have set up a table with 3 rows. 2. The user inserts financial amounts in Row 1 and 2. 3. I have set up Row 3 with a Sum(Above) formula. 4. Next to the formula, I have placed a macrobutton that runs a macro which updates the field (ie. the total of the table). 5. The display text of the macrobutton is 'Calculate'. 6. After a user double-clicks on it and the field is updated, I would like the word 'calculate' to no longer appear (or ideally, to not appear in the printed version). Thank you. |
Thread Tools | |
Display Modes | |
|
|