Macro's

[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.

 

[Dave Peterson]

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.)