Why do macros disable themselves? How to reenable them?

  • Thread starter Thread starter sallyember
  • Start date Start date
S

sallyember

When I open a previously-used workbook, sometimes when I begin to fil
in cells, the message pops up FOR EACH CELL (very annoying!) that th
macros are disabled, but all I did was reopen a used workbook!?!?!

How to stop this from happening, and how to reenable macros onc
they're disabled, please
 
Hi
maybe you're using a user defined function (which won't work with
macros disabled). To enable them close the workbook and open it again.
Say 'Yes' to the question if you want to enable macros
 
You must log in or register to reply here.

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

Similar Threads

How to turn macro back on? 1
File opens with Enable or Disable Macro 1
XL 2007 Macro Security warning 1
Excel files - macros & links 4
Macro? 1
How to disable the Macro? 1
Macros, How do I know what they do if I didn't create them. 1
Repost: Disabling Update Links dialog box 3

Back
Top