Macro's

  • Thread starter Thread starter Gail
  • Start date Start date
G

Gail

I'm creating a worksheet that contains check boxes. Upon
opening the file at a later date, I get an error when
trying to change from design view to normal view. The
error says that the file was opened without enabling the
macros. I did not get a prompt to enable any macros when
I opened the file. And there doesn't seem to be any
macros listed in the file at this time.

What do I need to do to get this corrected so that I can
continue to work in design view and work with the
worksheet normally?

Thank you in advance for any help that can be offered.
 
Maybe your security level is set too high.

In xl2k+, you can set to High and that disables any macros with no prompt to
you.

Take a look at Tools|macros|security

(if that wasn't it, post back with your version of excel--it may help the next
person responding.)
 
Back
Top