ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Macros help (https://www.excelbanter.com/excel-worksheet-functions/180101-macros-help.html)

Joann

Macros help
 
I accidentally hit disable on my workbook then closed. Now when I try to open
my workbook (that now has a xlms extention) I get This file is not a
recognizable format, how do I get my work back to where it was?


Ron de Bruin

Macros help
 
I accidentally hit disable on my workbook then closed
Please more info

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Joann" <u42112@uwe wrote in message news:81255c8f3f50c@uwe...
I accidentally hit disable on my workbook then closed. Now when I try to open
my workbook (that now has a xlms extention) I get This file is not a
recognizable format, how do I get my work back to where it was?


ilia

Macros help
 
Do you mean xlsm? You can't just rename the file .xlsm from .xlsx,
you must save it as a macro-enabled workbook. If this is what you
did, change the extension back and you'll be able to open the file -
but you won't be able to recover your macros.


On Mar 14, 9:59 am, "Joann" <u42112@uwe wrote:
I accidentally hit disable on my workbook then closed. Now when I try to open
my workbook (that now has a xlms extention) I get This file is not a
recognizable format, how do I get my work back to where it was?



Joann via OfficeKB.com

Macros help
 
Ron de Bruin wrote:
I accidentally hit disable on my workbook then closed

Please more info

I accidentally hit disable on my workbook then closed. Now when I try to open
my workbook (that now has a xlms extention) I get This file is not a
recognizable format, how do I get my work back to where it was?


I have no idea how it happened but I was told to down load a convertor for
excel (2007 convertor) and then open. It worked, and I don't understand since
I built it in 2003. I guess since I got it to work I shouldn't complain. But
it still puzzles me how this happened. Thanks for the help.

--
Message posted via http://www.officekb.com



All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com