Customizing Excel 2007

S

Schizoid Man

Hi,

I do a lot of date manipulation and would like to add a shortcut Date Format
of DD-Mmm-YY to either the ribbon (under Home in Number drop-down list) or
to the Quick Access toolbar on top of the screen. Any help is appreciated.

Regards,
Schiz
 
B

Bob I

Record the macro to do the cell format, then put the "button" for that
macro on the QAT.
 
S

ShaneDevenshire

Hi,

If you use the command a lot, record the macro and assign a shortcut key.
Also consider putting the macro in the Personal Macro Workbook
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying add-in function on ribbon bar in Excel 2007 2
Custom Number Formats for Excel 2007 1
Change date format in Excel footer 2
VBA in Excel 2007 date formatting 2
Multiple Toolbars in Excel 2007 2
Concatenated Dates? 1
Excell 2007 Dates and combining 2 cells 6
Excel 2003 toolbars in Excel 2007 3

Top