ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2000 Font Format Issue (https://www.excelbanter.com/excel-discussion-misc-queries/239930-excel-2000-font-format-issue.html)

tess

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.

Gord Dibben

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.



tess

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.


tess

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.




Dave Peterson

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

tess

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


tess

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