ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Don't know where to look for error (https://www.excelbanter.com/setting-up-configuration-excel/207592-dont-know-where-look-error.html)

Brenda

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

Dave Peterson

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

Brenda

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


Gord Dibben

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.




All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com