Thursday

Microsoft Office 2003 Customize a Toolbar Button

Did you know...



You can customize buttons on your toolbar, including macro buttons. Here are the simple steps.



  • Click on Tools

  • Click on Customize

  • Click on the Commands Tab

  • Click on icon you want to change

  • Click on Modify Selection

  • Put a checkmark next to Default Style

  • Click on Modify Selection again

Do one of two things:


Click on Change button image and select a predesigned image





















OR




Click on Edit button image and using the color boxes draw your own design





















When finished close all windows and see the new and improved button you just created



Doesn't work for you?

Email me at grandberry@gmail.com



We help you like your computer

How NOT To Use Powerpoint By Comedian Don McMillan

PowerPoint Tips

Wednesday

Excel 2003 Macro Buttons Tips & Tricks August 2007

Excel 2003 Macro Buttons

Did you know?

You can create a button (rather than just a keystroke) for macros you create in Excel?

Assuming you know how to make a macro...

After you create the macro,
  1. Right click on the toolbar
  2. Click on customize
  3. Click on the commands tab
  4. Select MACRO from the Left column
  5. From the Right column drag the macro CREATE CUSTOMIZE BUTTON and drop it on a toobar
  6. Right click on button and choose ASSIGN MACRO
  7. Select macro from next window that opens
  8. Close the customize window

You now have a macro button on your toolbar to complete a task with one click.

Next month, how to customize a macro button.

Comments welcome. Is there a tip you need to know, put it in the comments and I will include it in future Tips & Tricks.

We will help you like your computer.

Doesn't work for you? Send me an e-mail and I will help you.sandi@fortheloveofsoftware.com