LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Repetive Formatting/Creating a Toolbar button

Hi:

I work on different worksheets all of the time and have to choose format (on
different cells specific font withing the cell). I normally right click on
the font within the cell I need to format and choose format, select Font,
change the color to red, and choose strike through. How do I create a button
so that whenever I want to format any cell that I want to, I can have those
steps done immediately by clicking on a button.

I also sometimes need to format font so that is just green in color.

All this I want this button to be on the toolbar no matter which workbook I
am working on. I want it to be there all of the time.


Thank you.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Toolbar button fda secretary Excel Discussion (Misc queries) 1 October 22nd 07 09:41 PM
Excel: Toolbar button for Formatting cells to date STYLES etc Pauline from Perth Aus. Setting up and Configuration of Excel 0 June 6th 06 03:46 AM
Sum Button Toolbar Rugdoody Excel Discussion (Misc queries) 3 May 20th 06 12:38 AM
Creating a macro that simulates some of the toolbar button Duangruthai New Users to Excel 1 April 22nd 06 12:12 AM
Cell Formatting via Toolbar Button FuadsCurse Excel Worksheet Functions 0 March 22nd 06 07:41 PM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"