View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad E. Brad E. is offline
external usenet poster
 
Posts: 76
Default Changing a menu button in my XL template

Hi, all,

I would prefer if the "Comma Style" button were set up differently for me
EVERY time I use Excel 2007.

By recording a macro, and going to Home Styles Cell Styles Number
Format (right-click on) Comma Modify, then changing the format how I want
it, the following code was produced:
With ActiveWorkbook.Styles("Comma")
.IncludeNumber = True
.IncludeFont = False
.IncludeAlignment = False
.IncludeBorder = False
.IncludePatterns = False
.IncludeProtection = False
End With
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"

Is there a way to have this code run every time I open Excel?

I have already attempted this, and there are 2 files in my XLSTART folder:
Book.xlsx
Book.xltx
I assume I will have to save a file to my XLSTART folder - but which format
should I use? and should I get rid of either of the two files which are
currently in there?
--
TIA, Brad E.