#1
|
|||
|
|||
Format features predetermined
I can set as by default two format features only: font and size (through Excel>Options>General).
But I need to have three others predetermined: two decimals, separator of thousands and red for negative figures; how I can set those by default too, so as to have them operative on launching Excel? Thanks for any help. ACA |
#2
|
||||
|
||||
Create an appropriately-formatted template. See: Save a workbook as a template - Excel
For some Excel template examples, see: Free Excel for the web templates on Office.com - Excel
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you very much; I'll try that.
ACA |
#4
|
|||
|
|||
Hi, macropod; a little snag with that solution:
If I open first this empty template with my new format, and once inside it I call an existing file, this one opens in another window, as an independent file. So the empty template behaves as if it were already one more Excel file, only an empty one. I'd like it to behave just like the original template; where files open within it, filling the empty template with the content of the file opened. Or else, what would amount to the same: I'd like to just reach to the original predetermined template and edit it with the features I need instead of the default ones. ACA |
#5
|
||||
|
||||
That is not how templates work. And, if you think about it, you really wouldn't want your template overriding the formatting of every workbook you open. Templates form the basis for new workbooks, not for overriding the format of existing ones.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
|||
|
|||
Thanks, macopod, for keeping assisting me.
No, I wouldn't want this new template of mine to override the format of every existing Excel file it receives. But that's not what the original template in Excel does. This primal template also respects the formats of the several files that get opened into it; yet these open in the workbook and file started by the template, not in a second workbook or file. That's how I want my new personal template to work. Not possible? Thanks again. ACA |
#7
|
||||
|
||||
As I said, that's simply not how templates work, whether original or otherwise. What you're after would require the use of an Auto_Open macro that uses brute force to reformat every workbook you open - and a Worksheet_SelectionChange macro to reformat every edit you make. Expect Excel to run quite slowly when opening large files if you do that, as the Auto_Open macro would have to test every cell's format so it doesn't reformat dates, percentages, etc.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#8
|
|||
|
|||
O.K. That's clear, and clear cut; and I duly submit to the facts as they really are and not as I would have them behave.
Thank you most sincerely, macropod. ACA |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Save to PDF with predetermined filename and specific folder path | cutemich | Word VBA | 1 | 05-09-2017 06:27 PM |
OL 365 missing features? | markg2 | Outlook | 0 | 04-19-2016 05:12 AM |
Format tab features for photo are dimmed under protected doc | vvcat | Word | 9 | 03-03-2015 07:10 PM |
Save As PDF Macro/VBA with Predetermined File Name | DefinedDesign | Word VBA | 9 | 10-29-2014 01:48 PM |
save a file with a predetermined date in VBA | lingering | Word VBA | 1 | 03-23-2014 07:47 PM |