How to turn macro back on?

  • Thread starter Thread starter Herbert Chan
  • Start date Start date
H

Herbert Chan

Hello,

I've a spreadsheet and I can see that there's a macro inside. However, when
I try to run it, Excel told me the spreadsheet has been opened with macro
disabled. There's no pop up dialog box that asks me if i will like to open
the macro with this spreadsheet when I open the file. I cannot find a way
to reenable the macro.

So how can I turn the macro back on?

Thanks.

Herbert
 
Herbert,

It seems your macro security level is currently set to High. Follow menu
path Tools > Macro > Security to change to Medium, so you are prompted
whether you want to enable macros or not when opening a workbook with one or
more macros.

HTH,
Nikos
 

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

Back
Top