Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Undo button in the context menu (right click menu) | Excel Programming | |||
How would I remove a drop down menu from an excel template? | Excel Discussion (Misc queries) | |||
custom menu not showing in template file | Excel Programming | |||
Changing a template in excel | Excel Discussion (Misc queries) | |||
Create floating button based on button click in menu | Excel Programming |