Worksheet function in excel only works once

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

Guest

I have successfuly written a worksheet function in Excel using VBA. However
when I return to the spreadsheet after saving it, the function no longer
works. I receive an error message from visual basic which says that the
macros are deactivated, but gives no clue how to reactivate them.
 
Examine your settings at Tools>Options>Security tab, Macro security. That is
the path in Excel 2003, it may be different in other versions.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
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 Copying Worksheets 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Combining Macros and if function 2
Excel Trying to code an Array Function in VBA Excel to works as a MaxIF 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7
Help with Excel if function and macros 3
HYPERLINK Worksheet Function 3

Back
Top