deleting mysterious macro

[Ben]

Hi,

I have a macro that I notice loads at start up of Exel (2002). If I go to
the VB editor it is listed in the project window above "VBAProject (Book1)"
and is called "funcres (FUNCRES.XLA)". If I click on it a password dialogue
comes up. I didn't put the macro there and do not know what it is for or
what it is doing. How can I get rid of it or disable it or something
(preferably having the option to do both). If I go into Tools/Macro/Macros
nothing is listed there.

Thanks for any help you can give.
regards,
Ben


--
"What passes for wisdom may only be eloquent foolishness"

Cheap long distance calling using Onesuite (http://www.onesuite.com).
2.5 cents/min anywhere in the U.S., to Canada or the U.K. No monthly or
connection fees! Use promotional code 038664643 for 20 free minutes.

 

[Frank Kabel]

Hi
this is the Analysis Toolpak add-in (to disable this goto 'Tools -
Add-in manager' and uncheck this add-in

 

[Bob Phillips]

Ben,

Ignore it, don't worry about it, and sleep well at night!

The file is the Analysis Toolpak which has been installed in Excel (Adds
NETWORKDAYS function etc.), so it is legitimate, and should be left alone.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Ben]

Ignore it, don't worry about it, and sleep well at night!

The file is the Analysis Toolpak which has been installed in Excel (Adds
NETWORKDAYS function etc.), so it is legitimate, and should be left alone.

Ah. In that case I caused it to load myself because I used a function
called eomonth which I somehow stumbled on and was instructed by the help
to install a toolpak thing to make it work. How do you find out all the
functions in a addin anyway? They don't get listed in the normal function
menu item.

Thanks,
Ben



--
"What passes for wisdom may only be eloquent foolishness"

Cheap long distance calling using Onesuite (http://www.onesuite.com).
2.5 cents/min anywhere in the U.S., to Canada or the U.K. No monthly or
connection fees! Use promotional code 038664643 for 20 free minutes.

 

[Dave Peterson]

From Norman Harker's signature:

Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

And Peter Nonely has lots of functions and explanations at:

http://homepage.ntlworld.com/noneley/