Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Caculator on Tool Bar (MS OFFICE 2000)

    I discovered how to put a calculator on my tool bar in Excel. This was wonderful, it is like the windows calculator. Now I would love to have the same thing on
    my MS Word Tool Bar ... ? I tried for about 1.5 hours all kinds of things to import the calculator, to move the one from Excel to the desktop and then into Word, nothing I tried worked, any help out there ... ?
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    Word has a wimpy calculate button that works like this: Type 2+2 then select the sum then click the calculate button. The status bar will tell you the answer is 4. You probably want something a bit more powerful, so I won't even tell you how to put the "ToolsCalculate" button on your toolbar.

    Instead, put the following little snippet in a Normal.dot code module and add a button for it on your toolbar of choice via Tools>Customize>Commands>Macros.

    Sub ToolsCalculator()
    Dim ret As Variant
    ret = Shell("calc.exe", vbNormalFocus)
    End Sub
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    Very nice! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    Charles Kyle Kenyon
    Madison, Wisconsin

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    London, Gtr London, England
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    That is really useful - thanks. Word even has a cute little calculator button just for the toolbar!

  5. #5
    BAM
    Guest

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    Although the actual calculator is better, but Word does have a Tools Calculate command. You can add it to a toolbar from the Tools category in the Customize dialog box.

    All you do is type a formula, such as 2*3, select it and click Tools Calculate and the result displays in the Status Bar.
    ~~~~~~~~~~~~~
    Cheers!

  6. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    You didn't read the top post, did you?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  7. #7
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    I like that sig; looks great on the white background of the email message. If I ever retire Kevin McCalister, I think I'll do a sig.

    Glad you found the code useful.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  8. #8
    BAM
    Guest

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    <img src=/S/doh.gif border=0 alt=doh width=15 height=15>!!!!!!!

    I Completely missed it!

    I noted your macro for the Windows calculator and missed the rest.

    Sorry Kevin! I know what it is like to have someone come along hours later and post the same information as you did. What really gets me is when they do it as a reply to your post!

    So <img src=/S/warts.gif border=0 alt=warts width=59 height=24> to me on this one! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    ~~~~~~~~~~~
    Cheers! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  9. #9
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    Azokay. I hope the "acne" clears up soon. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  10. #10
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    I do not want to calculate, but I want the calculator like
    the one with windows, which can switch from Scientific to standard an back. In Excel you can put this icon on the tool bar.....
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  11. #11
    2 Star Lounger rjbphillipsiii's Avatar
    Join Date
    Mar 2003
    Location
    Memphis, Tennessee, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    Well Kevin, everyone seems happy, but I am still no where, I have no idea what you ment by the snipit or whatever it is called, and now my question is cluttered by all this other feedback which is of no help to me, all
    I am doing is spending a bunch of time reading comments ...? this has not helped me a bit ... <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    R.J.B. Phillips III
    Logical Systems Inc. Part Time Drafter
    IBC WONDER HOSTESS Retired 33+ years
    Firestone Tr & Rubber Company 15 Years rjbphillipsiii@yahoo.com

  12. #12
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    Kevin's message has one answer, but if you are not the VBA type, it's probably not worth your time. Consider this alternative method: if you are using Windows 98 or ME, put the calculator icon on the QuickLaunch bar. This would not require any macro programming, it would be accessible from everywhere, and it's easily done on other PCs you might be forced to visit during the course of your week.

    Technique:

    (1) Make space on your QuickLaunch bar
    (2) Flip open the start menu to Programs, Accessories
    (3) Right click and drag on the Calculator icon to the QuickLaunch bar and position the black insertion point where you want the new icon
    (4) Release and choose Copy from the pop-up menu to create your icon

  13. #13
    BAM
    Guest

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    Hi RBJ,

    Glad you asked about this for you too can be just as happy. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    The snippit that Kevin posted is a macro that you can use to call the Windows calculator.

    To use the macro follow these steps:

    - Copy this lines of the macro between Sub ToolsCalculator() and End Sub (You will be recreating these two lines later.
    - Go to Tools/Macro/Macros and Type: ToolsCalculator in the Macro name text box
    - Click the "Create" command
    - Paste the previously copied lines in between Sub ToolsCalculator() and End Sub

    You now have the macro. To add it to your Toolbar:

    - Right-click any Toolbar and select Customize
    - On the Commands tab locate Macros and select it
    - The macro you just created will be listed on the right
    - Click and hold the macro name and drag it to a location of your choice on any Toolbar
    - To further customize the button, right-click the button you just added and select "Default Style"
    - Right-click again and under "Change Button Image" you will find the calculator icon
    - Select it and close Customize and try your new button! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    ~~~~~~~~~~~~~~~
    Cheers!

  14. #14
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    RJB,

    Well no need to be snippy <img src=/S/smile.gif border=0 alt=smile width=15 height=15>. I cut out those snippets every now and then too.

    Here's a partial solution that may give you what you want and more. It's not a perfect solution (but pretty close) but maybe the people on the lounge smarter than me can improve on it. That leaves it open to almost every one.

    First, one of the things that I didn't see mentioned in any of the responses mentioning the Tools Calculate command is that the answer is also stored in the clipboard. So you can paste the answer next to your equation without having to copy the answer. Helps when you're trying to compute the value of pi and don't want to miss the 98th digit. But I didn't discover this on my own. It came from the lounge somewhere. Told you there were lots of smart people here. But I know this is not what you want.

    Now to my partial solution: Go to the web.

    When using Word's customize capability, you can put a button corresponding to 1 of several Web commands onto your toolbar. However, you don't even have to do this much. If you open the Web toolbar (and I know that some people hate this; I'm one of them but this trick might change my mind), you'll see a couple of buttons that are of use. Alternatively, you can drag the button from the Web commands onto one of your existing toolbars that's always open (like the Formatting or Std toolbar or Menu bar).

    The buttons I'm talking about are
    - Favorites
    - Open Favorites

    To a degree, these do roughly the same. The latter opens your Favorites folder (like an open dialog) while the latter just has a drop-down with your Favorites, including sub-menu items for sub-folders within Favorites.

    Now all you have to do is stick a short-cut for calc.exe into the Favorites folder and you're done - almost. You might even want to get organized and create a subfolder for Programs and put in shortcuts for all the programs you'd want to open from within word, excel, powerpoint...

    On my PC (running Win 98, Ofc 97 and IE 5.0), I get a msg box that says "some files may contain viruses...". This is the part where some help might be useful - to avoid this msg box. But click OK. Voila - calc opens up. I don't think any virus writers have written viruses to infect calc.exe.

    You can also do the above in 1 step more but why? There is another web command to Open an object at an address. Put this on your toolbar. There is also a command for Go, which presents a menu with Open as its first choice. Either way, you get an open dialog with an empty text box asking for an "Address". Type the path for calc (usually something like C:windowscalc.exe) (or just browse to the file) and press OK. You then get the virus warning per above. Proceed as above.

    I think the last para above is a waste but just wanted to be complete. Another problem with it is that the file is not sticky. When you click open again, you have a blank text box. However, all of your things that you opened are in the drop-down for the Address box. But this may not last forever as you open other things on the web.

    The Favorites approach is a no-brainer.

    If you don't have IE loaded, this is totally worthless. If you do, I hope this helps a little.

    I can almost talk myself into believing Bill's argument that IE is part of the operating system. Almost.

    By the way, how do you get that button for calc.exe onto your Excel toolbar. I think I saw a post on the excel lounge for how to do this, but I forgot.

    Fred

  15. #15
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Caculator on Tool Bar (MS OFFICE 2000)

    Richard,

    Well, you do have to make a small effort to put that code into a Normal.dot module. Is that the part you are having trouble with? If you want to try that with some more instructions, I'd be glad to walk you through the steps. Let me know. Better yet, see BAM's post just below. She lays it out very clearly.

    I like Jefferson's, idea too. If you just drag and drop the calculator to the Quicklaunch bar (to the right of the Windows Start button), you'll have a calc button for every program.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •