Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MacroButton field doesn't start macro | Microsoft Word Help | |||
Create summary Formula field that automatically updates | Tables | |||
how to align caption of formula right whereas formula itself left | Microsoft Word Help | |||
MACROBUTTON macro dropdown list | Microsoft Word Help | |||
Creating a macro that updates table fields | Microsoft Word Help |