|
Excel 2002: Can I default font color for every new file created ?
Dear Sir,
I do not have any problem in defaulting font type and font size for every new file I open. I do it by going to Tool Option Font Howeer when come to defauting the font color, I can default one file at a time by going to Format Style. When a new file is opened, it goes by to its original default font color of black. May I know is there anyway to default it to blue color throughout for all new files ? Thanks Low -- A36B58K641 |
Excel 2002: Can I default font color for every new file created ?
Hi Mr. Low
You can create a template Save a workbook with the font color and font size you want as Book.xlt (template) Copy this file in your xlstart folder. Where it is: You can find the file in the Excel startup folder C:\Documents and Settings\<UserName\Application Data\Microsoft\Excel\XLSTART With code you find the path with this line MsgBox Application.StartupPath Every new file you open now have the settings of this file -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Dear Sir, I do not have any problem in defaulting font type and font size for every new file I open. I do it by going to Tool Option Font Howeer when come to defauting the font color, I can default one file at a time by going to Format Style. When a new file is opened, it goes by to its original default font color of black. May I know is there anyway to default it to blue color throughout for all new files ? Thanks Low -- A36B58K641 |
Excel 2002: Can I default font color for every new file create
Hello Ron,
The Excel 2002 I am using is installed at a server. It is a share program use by large number of office staff. The IT administrator disallow access to the program file. I am not able to use the method you recommended. May I know if there are some other ways of defaulting the font color ? Kind Regards Low -- A36B58K641 "Ron de Bruin" wrote: Hi Mr. Low You can create a template Save a workbook with the font color and font size you want as Book.xlt (template) Copy this file in your xlstart folder. Where it is: You can find the file in the Excel startup folder C:\Documents and Settings\<UserName\Application Data\Microsoft\Excel\XLSTART With code you find the path with this line MsgBox Application.StartupPath Every new file you open now have the settings of this file -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Dear Sir, I do not have any problem in defaulting font type and font size for every new file I open. I do it by going to Tool Option Font Howeer when come to defauting the font color, I can default one file at a time by going to Format Style. When a new file is opened, it goes by to its original default font color of black. May I know is there anyway to default it to blue color throughout for all new files ? Thanks Low -- A36B58K641 |
Excel 2002: Can I default font color for every new file create
You can do the same (save the file you changed as a template)
Give it a easy name ("MyTemplate" or so). And open it if you want a new workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Hello Ron, The Excel 2002 I am using is installed at a server. It is a share program use by large number of office staff. The IT administrator disallow access to the program file. I am not able to use the method you recommended. May I know if there are some other ways of defaulting the font color ? Kind Regards Low -- A36B58K641 "Ron de Bruin" wrote: Hi Mr. Low You can create a template Save a workbook with the font color and font size you want as Book.xlt (template) Copy this file in your xlstart folder. Where it is: You can find the file in the Excel startup folder C:\Documents and Settings\<UserName\Application Data\Microsoft\Excel\XLSTART With code you find the path with this line MsgBox Application.StartupPath Every new file you open now have the settings of this file -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Dear Sir, I do not have any problem in defaulting font type and font size for every new file I open. I do it by going to Tool Option Font Howeer when come to defauting the font color, I can default one file at a time by going to Format Style. When a new file is opened, it goes by to its original default font color of black. May I know is there anyway to default it to blue color throughout for all new files ? Thanks Low -- A36B58K641 |
Excel 2002: Can I default font color for every new file create
Hello Ron,
I have saved a worksheet called "Book" under C:\Documents and Settings\<UserName\Application Data\Microsoft\Excel\XLSTART. When I launch MS Excel by opening the first file "Book" the default settings is intact. However when I click at File New , the new file " Book 1" does not have the font color and color template setting I needed. The samething occurs for any all ither new files open such as "Book 2", "Book 3" and so on. May I know is there a way to keep the defalt settings of the file "Book" in other new files open ? Thanks Low -- A36B58K641 "Ron de Bruin" wrote: You can do the same (save the file you changed as a template) Give it a easy name ("MyTemplate" or so). And open it if you want a new workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Hello Ron, The Excel 2002 I am using is installed at a server. It is a share program use by large number of office staff. The IT administrator disallow access to the program file. I am not able to use the method you recommended. May I know if there are some other ways of defaulting the font color ? Kind Regards Low -- A36B58K641 "Ron de Bruin" wrote: Hi Mr. Low You can create a template Save a workbook with the font color and font size you want as Book.xlt (template) Copy this file in your xlstart folder. Where it is: You can find the file in the Excel startup folder C:\Documents and Settings\<UserName\Application Data\Microsoft\Excel\XLSTART With code you find the path with this line MsgBox Application.StartupPath Every new file you open now have the settings of this file -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Dear Sir, I do not have any problem in defaulting font type and font size for every new file I open. I do it by going to Tool Option Font Howeer when come to defauting the font color, I can default one file at a time by going to Format Style. When a new file is opened, it goes by to its original default font color of black. May I know is there anyway to default it to blue color throughout for all new files ? Thanks Low -- A36B58K641 |
Excel 2002: Can I default font color for every new file create
Save it as a template(xlt), not xls
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Hello Ron, I have saved a worksheet called "Book" under C:\Documents and Settings\<UserName\Application Data\Microsoft\Excel\XLSTART. When I launch MS Excel by opening the first file "Book" the default settings is intact. However when I click at File New , the new file " Book 1" does not have the font color and color template setting I needed. The samething occurs for any all ither new files open such as "Book 2", "Book 3" and so on. May I know is there a way to keep the defalt settings of the file "Book" in other new files open ? Thanks Low -- A36B58K641 "Ron de Bruin" wrote: You can do the same (save the file you changed as a template) Give it a easy name ("MyTemplate" or so). And open it if you want a new workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Hello Ron, The Excel 2002 I am using is installed at a server. It is a share program use by large number of office staff. The IT administrator disallow access to the program file. I am not able to use the method you recommended. May I know if there are some other ways of defaulting the font color ? Kind Regards Low -- A36B58K641 "Ron de Bruin" wrote: Hi Mr. Low You can create a template Save a workbook with the font color and font size you want as Book.xlt (template) Copy this file in your xlstart folder. Where it is: You can find the file in the Excel startup folder C:\Documents and Settings\<UserName\Application Data\Microsoft\Excel\XLSTART With code you find the path with this line MsgBox Application.StartupPath Every new file you open now have the settings of this file -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Dear Sir, I do not have any problem in defaulting font type and font size for every new file I open. I do it by going to Tool Option Font Howeer when come to defauting the font color, I can default one file at a time by going to Format Style. When a new file is opened, it goes by to its original default font color of black. May I know is there anyway to default it to blue color throughout for all new files ? Thanks Low -- A36B58K641 |
Excel 2002: Can I default font color for every new file create
Hello Ron,
I save the file again as Book.xlt, but still facing the same problem as before. Is there any method of overcoming this ? Thanks Low -- A36B58K641 "Ron de Bruin" wrote: Save it as a template(xlt), not xls -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Hello Ron, I have saved a worksheet called "Book" under C:\Documents and Settings\<UserName\Application Data\Microsoft\Excel\XLSTART. When I launch MS Excel by opening the first file "Book" the default settings is intact. However when I click at File New , the new file " Book 1" does not have the font color and color template setting I needed. The samething occurs for any all ither new files open such as "Book 2", "Book 3" and so on. May I know is there a way to keep the defalt settings of the file "Book" in other new files open ? Thanks Low -- A36B58K641 "Ron de Bruin" wrote: You can do the same (save the file you changed as a template) Give it a easy name ("MyTemplate" or so). And open it if you want a new workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Hello Ron, The Excel 2002 I am using is installed at a server. It is a share program use by large number of office staff. The IT administrator disallow access to the program file. I am not able to use the method you recommended. May I know if there are some other ways of defaulting the font color ? Kind Regards Low -- A36B58K641 "Ron de Bruin" wrote: Hi Mr. Low You can create a template Save a workbook with the font color and font size you want as Book.xlt (template) Copy this file in your xlstart folder. Where it is: You can find the file in the Excel startup folder C:\Documents and Settings\<UserName\Application Data\Microsoft\Excel\XLSTART With code you find the path with this line MsgBox Application.StartupPath Every new file you open now have the settings of this file -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Dear Sir, I do not have any problem in defaulting font type and font size for every new file I open. I do it by going to Tool Option Font Howeer when come to defauting the font color, I can default one file at a time by going to Format Style. When a new file is opened, it goes by to its original default font color of black. May I know is there anyway to default it to blue color throughout for all new files ? Thanks Low -- A36B58K641 |
Excel 2002: Can I default font color for every new file create
The Excel 2002 I am using is installed at a server. It is a share program
use by large number of office staff. It will use another XLSTART folder then I think Ask your IT people -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Hello Ron, I save the file again as Book.xlt, but still facing the same problem as before. Is there any method of overcoming this ? Thanks Low -- A36B58K641 "Ron de Bruin" wrote: Save it as a template(xlt), not xls -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Hello Ron, I have saved a worksheet called "Book" under C:\Documents and Settings\<UserName\Application Data\Microsoft\Excel\XLSTART. When I launch MS Excel by opening the first file "Book" the default settings is intact. However when I click at File New , the new file " Book 1" does not have the font color and color template setting I needed. The samething occurs for any all ither new files open such as "Book 2", "Book 3" and so on. May I know is there a way to keep the defalt settings of the file "Book" in other new files open ? Thanks Low -- A36B58K641 "Ron de Bruin" wrote: You can do the same (save the file you changed as a template) Give it a easy name ("MyTemplate" or so). And open it if you want a new workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Hello Ron, The Excel 2002 I am using is installed at a server. It is a share program use by large number of office staff. The IT administrator disallow access to the program file. I am not able to use the method you recommended. May I know if there are some other ways of defaulting the font color ? Kind Regards Low -- A36B58K641 "Ron de Bruin" wrote: Hi Mr. Low You can create a template Save a workbook with the font color and font size you want as Book.xlt (template) Copy this file in your xlstart folder. Where it is: You can find the file in the Excel startup folder C:\Documents and Settings\<UserName\Application Data\Microsoft\Excel\XLSTART With code you find the path with this line MsgBox Application.StartupPath Every new file you open now have the settings of this file -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr. Low" wrote in message ... Dear Sir, I do not have any problem in defaulting font type and font size for every new file I open. I do it by going to Tool Option Font Howeer when come to defauting the font color, I can default one file at a time by going to Format Style. When a new file is opened, it goes by to its original default font color of black. May I know is there anyway to default it to blue color throughout for all new files ? Thanks Low -- A36B58K641 |
| All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com