Workbook macro's

[CliveG]

I have been adding macro's to a workbook and made a typing error on one of
the names but did not realise until I went to add the macro to a button. As
the window opens to assign a macro it allows you to step into that VB editor
which I did do, I corrected the name, once I did this it corrupted all the
macro's in the window and I am unable to open the workbook with the macro's
enabled.

THe question is can I recover from this, if so where are the macro's stored
for workbooks. (I know where the personel ones are stored)

 

[Gary Fuller]

Sorry,
I have no solution but wish to add mine. I created two .xltm and now when I
try to open them I get:
"Excel cannot open the file 'TakeOff_CO.xltm' because the format or file
extension is invalid. Verify that the file has not been corrupted....etc.

 

[FloMM2]

Gary,
Did you try and rename your File"TakeOff_CO.xltm" to say
"TakeOff_CO.xlm" ?
Dennis

 

[Gary Fuller]

Thank you,
I did try this right away, with no success.
gary