philfer
08-28-2010, 06:26 AM
Hello,
When I am writing VBA and save the file as an xlsm file I get the "enable content" warning when I re-open the file (unless I set the folder up as a trusted location) which is what I expect
However sometimes after I have written some further code in an xlsm file I get the "this workbook contains encrypted macros" warning which doesnt let me enable the content.
I am the only one writing macros in the workbook and it often happens after I write a macro in the ThisWorkbook object
Does this happen to anyone else and does anyone know why it is happening and what I can do to deal with it. I delete the code I had just written but it still wont work and it is almost like the file is corrupted and I end up having to start from scratch and makes me look very slow and even more incompetant than I already do!!!!
Any advice?
Thanks
Phil
When I am writing VBA and save the file as an xlsm file I get the "enable content" warning when I re-open the file (unless I set the folder up as a trusted location) which is what I expect
However sometimes after I have written some further code in an xlsm file I get the "this workbook contains encrypted macros" warning which doesnt let me enable the content.
I am the only one writing macros in the workbook and it often happens after I write a macro in the ThisWorkbook object
Does this happen to anyone else and does anyone know why it is happening and what I can do to deal with it. I delete the code I had just written but it still wont work and it is almost like the file is corrupted and I end up having to start from scratch and makes me look very slow and even more incompetant than I already do!!!!
Any advice?
Thanks
Phil