Workbook macro's

  • Thread starter Thread starter CliveG
  • Start date Start date
C

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)
 
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.
 
Back
Top