Hi Group,

I have a module that was created in XL2000, which has been upgraded to 2003.
When i go to project explorer I have funcres(FUNCRES.XLA) visible. If i click
on the + to expand it, I am asked for a password. There is not password and I
do not know what this represents. Can anyone point me in the right direction
to figure this out?

--
David

Funcres.xla is the analysis toolpak.

You can toggle it on/off via tools|addins (within excel--not the VBE).

David wrote:

Hi Group,

I have a module that was created in XL2000, which has been upgraded to 2003.
When i go to project explorer I have funcres(FUNCRES.XLA) visible. If i click
on the + to expand it, I am asked for a password. There is not password and I
do not know what this represents. Can anyone point me in the right direction
to figure this out?

--
David

--

Dave Peterson

Why am I getting the possible access and the need for a password?


--
David


"Dave Peterson" wrote:

Funcres.xla is the analysis toolpak.

You can toggle it on/off via tools|addins (within excel--not the VBE).

David wrote:

Hi Group,

I have a module that was created in XL2000, which has been upgraded to 2003.
When i go to project explorer I have funcres(FUNCRES.XLA) visible. If i click
on the + to expand it, I am asked for a password. There is not password and I
do not know what this represents. Can anyone point me in the right direction
to figure this out?

--
David

--

Dave Peterson

The analysis toolpak is furnished as part of Excel. It is password
protected because its functionality is provided, not its code. (however,
most of the code is in compiled dll's anyway - so there isn't much to see).
Additionally, if you were permitted inside and changed things so it wouldn't
work, then that would be a problem.

--
Regards,
Tom Ogilvy


"David" wrote in message
...
Why am I getting the possible access and the need for a password?


--
David


"Dave Peterson" wrote:

Funcres.xla is the analysis toolpak.

You can toggle it on/off via tools|addins (within excel--not the VBE).

David wrote:

Hi Group,

I have a module that was created in XL2000, which has been upgraded to
2003.
When i go to project explorer I have funcres(FUNCRES.XLA) visible. If
i click
on the + to expand it, I am asked for a password. There is not
password and I
do not know what this represents. Can anyone point me in the right
direction
to figure this out?

--
David

--

Dave Peterson

It does not serve a purpose in the VBA area. When i look at the add-ins would
i want to toggle the analysis-pak off? I use the analysis functions in my
worksheets for sure. But I am only assuiming that I might use it in VBA.

In the end this is just curious and I am glad to know what the funcres.xla
is and why I was not able or allowed to access it. Thank you for the
information.
--
David


"Tom Ogilvy" wrote:

The analysis toolpak is furnished as part of Excel. It is password
protected because its functionality is provided, not its code. (however,
most of the code is in compiled dll's anyway - so there isn't much to see).
Additionally, if you were permitted inside and changed things so it wouldn't
work, then that would be a problem.

--
Regards,
Tom Ogilvy


"David" wrote in message
...
Why am I getting the possible access and the need for a password?


--
David


"Dave Peterson" wrote:

Funcres.xla is the analysis toolpak.

You can toggle it on/off via tools|addins (within excel--not the VBE).

David wrote:

Hi Group,

I have a module that was created in XL2000, which has been upgraded to
2003.
When i go to project explorer I have funcres(FUNCRES.XLA) visible. If
i click
on the + to expand it, I am asked for a password. There is not
password and I
do not know what this represents. Can anyone point me in the right
direction
to figure this out?

--
David

--

Dave Peterson

If you use the functions in the analysis toolpak in your workbook, then you'd
want to keep it turned on.

Just because it shows up in the VBE's project explorer doesn't mean that it has
to be used in your code.

In fact, you'll see all your workbooks that are open in that project
explorer--whether or not they have any code in them--or you use them in any
other code.

There is another addin named: Analysis TookPak - VBA
That you can turn off (via tools|addins in excel) if you never use it in code.

David wrote:

It does not serve a purpose in the VBA area. When i look at the add-ins would
i want to toggle the analysis-pak off? I use the analysis functions in my
worksheets for sure. But I am only assuiming that I might use it in VBA.

In the end this is just curious and I am glad to know what the funcres.xla
is and why I was not able or allowed to access it. Thank you for the
information.
--
David

"Tom Ogilvy" wrote:

The analysis toolpak is furnished as part of Excel. It is password
protected because its functionality is provided, not its code. (however,
most of the code is in compiled dll's anyway - so there isn't much to see).
Additionally, if you were permitted inside and changed things so it wouldn't
work, then that would be a problem.

--
Regards,
Tom Ogilvy


"David" wrote in message
...
Why am I getting the possible access and the need for a password?


--
David


"Dave Peterson" wrote:

Funcres.xla is the analysis toolpak.

You can toggle it on/off via tools|addins (within excel--not the VBE).

David wrote:

Hi Group,

I have a module that was created in XL2000, which has been upgraded to
2003.
When i go to project explorer I have funcres(FUNCRES.XLA) visible. If
i click
on the + to expand it, I am asked for a password. There is not
password and I
do not know what this represents. Can anyone point me in the right
direction
to figure this out?

--
David

--

Dave Peterson





--

Dave Peterson