If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Don't know where to look for error
When i open up my file i get the following error
Compile error in hidden module I don't have a clue where to begin to find the problem. -- Thank you, Brenda |
#2
|
|||
|
|||
Don't know where to look for error
I would think that the error included the name of the module.
You may want to share that name to see if it's a common problem. But in general, this error means that there is a problem with code. And the workbook's project that has the problem is protected (needs a password to view/change). In the VBE, you can protect the workbook's project by: Tools|VBAProject Properties|Protection tab If you go into the VBE and try to access that project, then you'll be asked for a password to continue. If you are the same Brenda with the .scrollarea problem, maybe you made a change in that workbook's project's code when you were trying to fix it. Brenda wrote: When i open up my file i get the following error Compile error in hidden module I don't have a clue where to begin to find the problem. -- Thank you, Brenda -- Dave Peterson |
#3
|
|||
|
|||
Don't know where to look for error
You really know your stuff it worked...i posted a question for you. Can you
please check it out it's about your formula for downloading the floating toolbar. -- Thank you, Brenda "Dave Peterson" wrote: I would think that the error included the name of the module. You may want to share that name to see if it's a common problem. But in general, this error means that there is a problem with code. And the workbook's project that has the problem is protected (needs a password to view/change). In the VBE, you can protect the workbook's project by: Tools|VBAProject Properties|Protection tab If you go into the VBE and try to access that project, then you'll be asked for a password to continue. If you are the same Brenda with the .scrollarea problem, maybe you made a change in that workbook's project's code when you were trying to fix it. Brenda wrote: When i open up my file i get the following error Compile error in hidden module I don't have a clue where to begin to find the problem. -- Thank you, Brenda -- Dave Peterson |
#4
|
|||
|
|||
Don't know where to look for error
Brenda
Just for info.................VBA code is not a "formula" as you have been stating. Code is code.............there are several types........event, macro, user defined functions among them A formula is something like =A1*B1 entered in a worksheet cell. Gord Dibben MS Excel MVP On Fri, 24 Oct 2008 06:03:00 -0700, Brenda wrote: You really know your stuff it worked...i posted a question for you. Can you please check it out it's about your formula for downloading the floating toolbar. |
Thread Tools | |
Display Modes | |
|
|