Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-04-2020, 12:50 AM
ACA ACA is offline Format features predetermined Windows 10 Format features predetermined Office 2010
Advanced Beginner
Format features predetermined
 
Join Date: Aug 2010
Posts: 31
ACA is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-04-2020, 01:39 AM
macropod's Avatar
macropod macropod is online now Format features predetermined Windows 7 64bit Format features predetermined Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 05-04-2020, 03:17 AM
ACA ACA is offline Format features predetermined Windows 10 Format features predetermined Office 2010
Advanced Beginner
Format features predetermined
 
Join Date: Aug 2010
Posts: 31
ACA is on a distinguished road
Default

Thank you very much; I'll try that.
ACA
Reply With Quote
  #4  
Old 05-06-2020, 10:59 AM
ACA ACA is offline Format features predetermined Windows 10 Format features predetermined Office 2010
Advanced Beginner
Format features predetermined
 
Join Date: Aug 2010
Posts: 31
ACA is on a distinguished road
Default

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
Reply With Quote
  #5  
Old 05-06-2020, 03:55 PM
macropod's Avatar
macropod macropod is online now Format features predetermined Windows 7 64bit Format features predetermined Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by ACA View Post
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.
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]
Reply With Quote
  #6  
Old 05-07-2020, 01:19 AM
ACA ACA is offline Format features predetermined Windows 10 Format features predetermined Office 2010
Advanced Beginner
Format features predetermined
 
Join Date: Aug 2010
Posts: 31
ACA is on a distinguished road
Default

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
Reply With Quote
  #7  
Old 05-07-2020, 01:32 AM
macropod's Avatar
macropod macropod is online now Format features predetermined Windows 7 64bit Format features predetermined Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #8  
Old 05-07-2020, 01:08 PM
ACA ACA is offline Format features predetermined Windows 10 Format features predetermined Office 2010
Advanced Beginner
Format features predetermined
 
Join Date: Aug 2010
Posts: 31
ACA is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format features predetermined 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 features predetermined Format tab features for photo are dimmed under protected doc vvcat Word 9 03-03-2015 07:10 PM
Format features predetermined 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft