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.

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.

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.

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.

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

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

"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