Unable to exit Design Mode

T

theschweik

Weird problem here. I've an existing workbook with a number of macros and
functions that I've been using successfully for some time with no issues (at
both home and work). At work, the workbook is, for some unknown reason, now
stuck in Design mode and I am unable to exit Design Mode, getting a message
that says macros are disabled. But they aren't (all macros work in all other
workbooks like they should).

I believe I can't use macros because the workbook is stuck in Design Mode.
I can't exit Design Mode because it thinks I've disabled macros. Catch-22.

Anyone have ideas? Thanks in advance!!!

Excel version 2007
 
P

Patrick Molloy

sorry - only thing that I can suggest is that you use task Manager to kill
it and try to re-open it
 
H

Howard31

Make sure that the Workbook (the one that is run in xl2007) is saved with
the 'xlsm' extension.

Hope this will solve the problem
 
T

theschweik

Howard, Patrick - THANKS, both of you!

Neither worked LOL - (tried both before, and all their variants - and then
tried them again after your replies).

BUT!!! Taken together, your responses did trigger thinking of another route
that DID work!

I saved the file, which was an XLTM file, as a regular XLSX file, which made
the file a regular Excel workbook, without macros enabled. Fortunately, it
saved the entire VBA environment and all my macros and functions; I lost none
of that in the saving. It also turned off Design Mode.

I then re-saved the file as an XLTM (I'm sure XLSM would work too) and lo
and behold - macros enabled, Design Mode off, and all functionality returned!
Gak, who'd a thunk?

Thanks again! Saving this for future mental reference :)
 
P

Patrick Molloy

pleased you resolved it.

theschweik said:
Howard, Patrick - THANKS, both of you!

Neither worked LOL - (tried both before, and all their variants - and then
tried them again after your replies).

BUT!!! Taken together, your responses did trigger thinking of another
route
that DID work!

I saved the file, which was an XLTM file, as a regular XLSX file, which
made
the file a regular Excel workbook, without macros enabled. Fortunately,
it
saved the entire VBA environment and all my macros and functions; I lost
none
of that in the saving. It also turned off Design Mode.

I then re-saved the file as an XLTM (I'm sure XLSM would work too) and lo
and behold - macros enabled, Design Mode off, and all functionality
returned!
Gak, who'd a thunk?

Thanks again! Saving this for future mental reference :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top