A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"automatic" AutoSum - can I insert a button?



 
 
Thread Tools Display Modes
  #1  
Old November 30th, 2007, 10:53 PM posted to microsoft.public.word.tables
klerner
external usenet poster
 
Posts: 1
Default "automatic" AutoSum - can I insert a button?

I am trying to update a performance review form for my office. One section
requires managers to input the percent of time spent on each job duty by the
employee. The departments want the bottom of the column to add up the
percentages so they don't have to figure out if the numbers they've entered
add up to 100%. I am trying to figure out a way to insert a button next to
the FINAL TOTAL cell on the table so the managers can easily see the new
total with one click of the button. We are using Word 2003 at the moment.
Any help???

  #2  
Old December 1st, 2007, 01:26 AM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default "automatic" AutoSum - can I insert a button?

If the total is a formula field, F9 will update it.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"klerner" u39505@uwe wrote in message news:7c0159ba8091b@uwe...
I am trying to update a performance review form for my office. One section
requires managers to input the percent of time spent on each job duty by
the
employee. The departments want the bottom of the column to add up the
percentages so they don't have to figure out if the numbers they've
entered
add up to 100%. I am trying to figure out a way to insert a button next
to
the FINAL TOTAL cell on the table so the managers can easily see the new
total with one click of the button. We are using Word 2003 at the moment.
Any help???




  #3  
Old December 1st, 2007, 07:44 AM posted to microsoft.public.word.tables
Graham Mayor
external usenet poster
 
Posts: 18,297
Default "automatic" AutoSum - can I insert a button?

Or if you want a button, use it to call the update macro at
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


Suzanne S. Barnhill wrote:
If the total is a formula field, F9 will update it.


"klerner" u39505@uwe wrote in message news:7c0159ba8091b@uwe...
I am trying to update a performance review form for my office. One
section requires managers to input the percent of time spent on each
job duty by the
employee. The departments want the bottom of the column to add up
the percentages so they don't have to figure out if the numbers
they've entered
add up to 100%. I am trying to figure out a way to insert a button
next to
the FINAL TOTAL cell on the table so the managers can easily see the
new total with one click of the button. We are using Word 2003 at
the moment. Any help???



  #4  
Old December 3rd, 2007, 11:06 PM posted to microsoft.public.word.tables
klerner via OfficeKB.com
external usenet poster
 
Posts: 1
Default "automatic" AutoSum - can I insert a button?

Thanks!!

Suzanne S. Barnhill wrote:
If the total is a formula field, F9 will update it.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...ables/200712/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.