Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Compile error in hidden module: Addition" what does it mean?!?!?
Can any one tell me what the following error message means
"Compile error in hidden module: Addition" The macro transfers values from text boxes and inserts into various cells after scrolling down to find the first available empty cell The macro was written with the aid of "Macros for dumbies" and I'm a complete novice so there are probably errors all over the place, but the macro has been working for about a year and then suddenly stopped working Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Compile error in hidden module: Addition" what does it mean?!?!?
The module named Addition is in a workbook's project that has been protected.
You'll have to unprotect that project (maybe supplying a password!) to find the error. And my bet is that if you're adding something, you've been typing in numbers in those textboxes for a year. Now you may be typing in something that doesn't look like a number to excel. Dave wrote: Can any one tell me what the following error message means "Compile error in hidden module: Addition" The macro transfers values from text boxes and inserts into various cells after scrolling down to find the first available empty cell The macro was written with the aid of "Macros for dumbies" and I'm a complete novice so there are probably errors all over the place, but the macro has been working for about a year and then suddenly stopped working Thanks in advance -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Compile error in hidden module: Addition" what does it mean?!?!?
Did you just upgrade to Excel 2007? I've had a number of things which worked
for a long time in previous versions suddenly start to produce errors like this in 2007. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave Peterson" wrote in message ... The module named Addition is in a workbook's project that has been protected. You'll have to unprotect that project (maybe supplying a password!) to find the error. And my bet is that if you're adding something, you've been typing in numbers in those textboxes for a year. Now you may be typing in something that doesn't look like a number to excel. Dave wrote: Can any one tell me what the following error message means "Compile error in hidden module: Addition" The macro transfers values from text boxes and inserts into various cells after scrolling down to find the first available empty cell The macro was written with the aid of "Macros for dumbies" and I'm a complete novice so there are probably errors all over the place, but the macro has been working for about a year and then suddenly stopped working Thanks in advance -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Compile error in hidden module: This WorkBook" only appears whenproject locked | Excel Programming | |||
Get a VB "Compile error in hidden module: DistMon" at start | Excel Discussion (Misc queries) | |||
How correct (or remove) "Compile error in hidden module: DistMon" | Excel Discussion (Misc queries) | |||
"compile error in hidden module": DISTMOD -- ideas to fix it?? | Excel Discussion (Misc queries) |