I can not open my "Test.xls" file

[FJSeminario]

I can not open my "Test.xls" file
I added a Variable which was a duplicate of another: dblJEAmt

I Clicked the [X] Close button to exit Excel.
A message box came up saying "Ambiguous Name Detected: dblJEAmt.
I clicked [OK]

Then another message box came up saying
"Do you want to save changes made to "Test.xls"
I clicked [Yes]

Now I can not open my excel file.
How can I open the file to access the Macro and correct the problem?

 

[kpark91]

Try disabling the macro settings by opening excel application (not opening the file)

Developer Ribbon > Macro Setting > Disable all macros with notification > OK

Then open your "Test.xls" file and fix your code from VBE.

 

[FJSeminario]

kpark91
I am sorry, I forgot to tell you I am running Excel 2003 on Windows XP Professional

Where is the Option to Disable all macros in Excel 2003?

I assume this is for Windows 7
Developer Ribbon > Macro Setting > Disable all macros with notification > OK

Thanks
FJSeminario

 

[FJSeminario]

kpark91

I figure it out, in Excel 2003 you do it this way

Tools > Macros > Security > Security level Tab > ( X ) Very High

Then open your "Test.xls" file and fix your code from VBE.

It now Works fine

Consider this Thread Resolved

Thanks a Million

FJSeminario