![]() |
Excel 2000 Font Format Issue
Help! I cant seem to save the font format setting on Excel 2000 everytime I
attempt to save the new settings and close the file. For example, fonts are currently in bold and font size is says it is at 12 but it looks more like 24! instead. So I've changed the setting to unbold and font size to 12 and then I save the excel file and close, but when I re-open the excel file, it goes back to the unwanted setting to the bold and 24 size font! Please help. Seems like these cells are protected but I looked to see if it is but it isn't. Thanks in advance. |
Excel 2000 Font Format Issue
Could be you have some event code running when you close or open the
workbook. Do you get a macro warning when opening the workbook? Gord Dibben MS Excel MVP On Mon, 17 Aug 2009 11:36:01 -0700, Tess wrote: Help! I cant seem to save the font format setting on Excel 2000 everytime I attempt to save the new settings and close the file. For example, fonts are currently in bold and font size is says it is at 12 but it looks more like 24! instead. So I've changed the setting to unbold and font size to 12 and then I save the excel file and close, but when I re-open the excel file, it goes back to the unwanted setting to the bold and 24 size font! Please help. Seems like these cells are protected but I looked to see if it is but it isn't. Thanks in advance. |
Excel 2000 Font Format Issue
Hi - no I don't get a macro warning when opening the workbook. What would be
the even code and how do I get rid of it? Thanks "Tess" wrote: Help! I cant seem to save the font format setting on Excel 2000 everytime I attempt to save the new settings and close the file. For example, fonts are currently in bold and font size is says it is at 12 but it looks more like 24! instead. So I've changed the setting to unbold and font size to 12 and then I save the excel file and close, but when I re-open the excel file, it goes back to the unwanted setting to the bold and 24 size font! Please help. Seems like these cells are protected but I looked to see if it is but it isn't. Thanks in advance. |
Excel 2000 Font Format Issue
Hi - no i dont get a macro warning when opening the workbook. What is an
event code and how do I get rid of it? "Gord Dibben" wrote: Could be you have some event code running when you close or open the workbook. Do you get a macro warning when opening the workbook? Gord Dibben MS Excel MVP On Mon, 17 Aug 2009 11:36:01 -0700, Tess wrote: Help! I cant seem to save the font format setting on Excel 2000 everytime I attempt to save the new settings and close the file. For example, fonts are currently in bold and font size is says it is at 12 but it looks more like 24! instead. So I've changed the setting to unbold and font size to 12 and then I save the excel file and close, but when I re-open the excel file, it goes back to the unwanted setting to the bold and 24 size font! Please help. Seems like these cells are protected but I looked to see if it is but it isn't. Thanks in advance. |
Excel 2000 Font Format Issue
And you're sure you're opening the file that you just saved, right?
Debra Dalgleish shows how to clean up all the remnants of macros: http://www.contextures.com/xlfaqMac.html#NoMacros Tess wrote: Help! I cant seem to save the font format setting on Excel 2000 everytime I attempt to save the new settings and close the file. For example, fonts are currently in bold and font size is says it is at 12 but it looks more like 24! instead. So I've changed the setting to unbold and font size to 12 and then I save the excel file and close, but when I re-open the excel file, it goes back to the unwanted setting to the bold and 24 size font! Please help. Seems like these cells are protected but I looked to see if it is but it isn't. Thanks in advance. -- Dave Peterson |
Excel 2000 Font Format Issue
Thanks.
"Dave Peterson" wrote: And you're sure you're opening the file that you just saved, right? Debra Dalgleish shows how to clean up all the remnants of macros: http://www.contextures.com/xlfaqMac.html#NoMacros Tess wrote: Help! I cant seem to save the font format setting on Excel 2000 everytime I attempt to save the new settings and close the file. For example, fonts are currently in bold and font size is says it is at 12 but it looks more like 24! instead. So I've changed the setting to unbold and font size to 12 and then I save the excel file and close, but when I re-open the excel file, it goes back to the unwanted setting to the bold and 24 size font! Please help. Seems like these cells are protected but I looked to see if it is but it isn't. Thanks in advance. -- Dave Peterson |
Excel 2000 Font Format Issue
"Dave Peterson" wrote: And you're sure you're opening the file that you just saved, right? Debra Dalgleish shows how to clean up all the remnants of macros: http://www.contextures.com/xlfaqMac.html#NoMacros Tess wrote: Help! I cant seem to save the font format setting on Excel 2000 everytime I attempt to save the new settings and close the file. For example, fonts are currently in bold and font size is says it is at 12 but it looks more like 24! instead. So I've changed the setting to unbold and font size to 12 and then I save the excel file and close, but when I re-open the excel file, it goes back to the unwanted setting to the bold and 24 size font! Please help. Seems like these cells are protected but I looked to see if it is but it isn't. Thanks in advance. -- Dave Peterson |
All times are GMT +1. The time now is 07:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com