Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code that I used in an Excel 2003 macro.
If NetWorkdays(Range("F38"), Range("G38"), ThisWorkbook.Sheets(3).Range("A1:A" & HolCount)) 14 Then ActiveSheet.CheckBoxes("Check box 27").Value = xlOn Else ActiveSheet.CheckBoxes("Check box 26").Value = xlOn End If I have converted the macro to Excel 2007 and, when I invoke the macro, I get a compile error - sub or function not defined. I have Analysis Tool-Pak VBA added in. I have atpvbaen as a reference as well as Excel and Office Object Librairies. What am I missing that is causing this problem? -- Ken Hudson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UDF Not recognized | Excel Worksheet Functions | |||
value not recognized as a formula | Excel Worksheet Functions | |||
UserForm_Initialize is not recognized?? | Excel Programming | |||
UDF not recognized after conversion to 2007 | Excel Programming | |||
Add-In not Recognized | Excel Programming |