Enabling macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet with some UDFs, and each time I open the worksheet, I get
a dialogue box asking if I want to enable macros. I click yes, and no
problem. However, I just updated Office 2000 from the MS update site, and
now the dialogue box asking if I want to enable macros NO LONGER appears when
I open the worksheet. Consequently, the UDFs don't work. When I change an
argument to the UDF, for exmaple, I get an error message saying that macros
are not enables. So, how do I enable macros, now that I no longer get the
enable macros box when i open the worksheet?
 
hi,
check your security and make sure it isn't set to low.
tool>Macro>security
 
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

Excel 2007 Macro Security 4
What wrong is macro with signcert? 6
Yes no drop down list and macros 4
Enable/Disbale Macro on opening Excel file 1
Enable Macros by Code 4
UDF can't be editted due to Excel 4 macro? 2
Macros in Excel Worksheet 7
Run Macros in a Password-protected workbook? 1

Back
Top