Hi All,
I am having a problem with a .xlsm file after converting it from 2003 to 2007.
When I initially opened the file the macros worked. As soon as I saved the
file and re-opened it, I received a "macros disabled/encryption" message and
they stopped working.
I did another conversion and the macros again worked. If I close the file
without saving and then re-open it, the macros continue to work. It's as if
as soon as the file is saved, the macros disable.
The only thing I have found is that when I look at the name of the macro in
the Macro Menu, it reads 'Test1.xlsm'.Module1.MACRO1' rather than just MACRO1.
It's like when you have more than one file open and it's showing you macros
in another workbook (even though the file name shown is the one I am having
issues with). I have "enabled all macros", "trusted access to the VBA project
object model" and also added the relevant foldes in the Trusted Source
centre, but to no avail.
Sorry for the long winded post.
Rgds,
Paul.
|
Similar Threads
