Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't get any of my functions to run in Excel 2007
I went into the VB editor, created a new module, wrote a buncha functions,
and when I go to use them in my spreadsheet I get #NAME?. When I type in the function name, Excel does know about the function because it appears in the dropdown. Also, if I try to debug my functions from the Immediate Window of the VB editor, I get a "the macros in this project are disabled" message. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't get any of my functions to run in Excel 2007
It may be the case that macros are disabled without notification.
To re-enable macros or notification in 2007, click the four colored squares icon in the upper left corner of the program window, then go down to Excel Options on the lower-right corner of the popup menu. Choose 'trust center' then 'trust center settings'. On the left will be a menu for all the different settings. Just a little buried. Hope that was helpful. "0to60" wrote: I went into the VB editor, created a new module, wrote a buncha functions, and when I go to use them in my spreadsheet I get #NAME?. When I type in the function name, Excel does know about the function because it appears in the dropdown. Also, if I try to debug my functions from the Immediate Window of the VB editor, I get a "the macros in this project are disabled" message. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't get any of my functions to run in Excel 2007
Hey
You might have your Macro Security level too high or you have disabled your macro "0to60" wrote in message ... I went into the VB editor, created a new module, wrote a buncha functions, and when I go to use them in my spreadsheet I get #NAME?. When I type in the function name, Excel does know about the function because it appears in the dropdown. Also, if I try to debug my functions from the Immediate Window of the VB editor, I get a "the macros in this project are disabled" message. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - keyboard functions | Excel Discussion (Misc queries) | |||
Excel 2007 -Where did the ALT-E functions go? | Setting up and Configuration of Excel | |||
JIS / ASC Functions in Excel 2007 | Excel Worksheet Functions | |||
2007 Excel Functions | Excel Discussion (Misc queries) | |||
2007 Excel Functions | Excel Worksheet Functions |