Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
mgirving mgirving is offline
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.word.tables
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MacroButton field doesn't start macro D Microsoft Word Help 5 October 6th 06 06:36 AM
Create summary Formula field that automatically updates ucmlamb Tables 4 July 15th 06 11:20 AM
how to align caption of formula right whereas formula itself left Martin van Leeuwen Microsoft Word Help 1 October 22nd 05 06:39 AM
MACROBUTTON macro dropdown list Leonard Microsoft Word Help 2 September 2nd 05 05:21 PM
Creating a macro that updates table fields Gail Microsoft Word Help 1 April 28th 05 11:56 PM


All times are GMT +1. The time now is 03:52 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"