Add-Ins - Go To Product - Part Duo

B

booismycat

Forgot to mention: I tried to Manage Add-Ins. There is nothing listed
associated with this issue.
I then added the ToolPak, Lookup Wizard, Solver, etc. They are listed in the
Manager but not on the Ribbon.
 
J

JLatham

In Excel 2007, if there are custom menus created in earlier versions of
Excel, they show up on the Add-Ins tab.

I'd open up the VB Editor (press [Alt]+[F11]) and examine the project for
any VBA code that may be in it. Just start down the list - first see if
there are any code modules listed. Once you've dealt with any code modules
(you can just delete them, of course you lose that functionality),
double-click on the names of each worksheet in the project window to see if
they have any code associated with them, and do the same for the ThisWorkbook
object.

As you find VBA code you'll have to make judgement calls as to whether to
delete it or not. To "delete" the code in worksheets/ThisWorkbook, simply
select all of the text and delete it.
 
B

booismycat

There is no code available under the VB Editor. The AppDev application
modified a library file or some other file external to Excel.exe as I deleted
all Excel files I've found to date and allowed Office 2007 to reinstall Excel.

In previous versions of Excel, one could create macros that would modify
your startup and this is what I'm thinking is my issue here. I just don't
know all the external files Excel touches at startup.

JLatham said:
In Excel 2007, if there are custom menus created in earlier versions of
Excel, they show up on the Add-Ins tab.

I'd open up the VB Editor (press [Alt]+[F11]) and examine the project for
any VBA code that may be in it. Just start down the list - first see if
there are any code modules listed. Once you've dealt with any code modules
(you can just delete them, of course you lose that functionality),
double-click on the names of each worksheet in the project window to see if
they have any code associated with them, and do the same for the ThisWorkbook
object.

As you find VBA code you'll have to make judgement calls as to whether to
delete it or not. To "delete" the code in worksheets/ThisWorkbook, simply
select all of the text and delete it.

booismycat said:
Forgot to mention: I tried to Manage Add-Ins. There is nothing listed
associated with this issue.
I then added the ToolPak, Lookup Wizard, Solver, etc. They are listed in the
Manager but not on the Ribbon.
 
J

JLatham

You could do a search of your system for *.xla files to find any that may be
laying around - or you can use the Office Button, choose [Excel Options] and
in the [Add-Ins] area, view all add-ins that Excel 2007 is "aware" of --
that'll point you right to them and you can see which are active.

Another possible source would be your Personal.xls file, and finally any
files that are in the Excel Startup folder are automatically loaded and fired
up when you open Excel. That folder is actually user definable in Excel 2007
and you can find out where it is (if anything has been set up) by choosing
the Advanced tab in the Excel Options window and scrolling down to the
GENERAL area - there's an entry in it that may be empty, or may show you
where something has gotten set up as a folder holding files to load at
startup, and you could check in it if anything is indicated there.


booismycat said:
There is no code available under the VB Editor. The AppDev application
modified a library file or some other file external to Excel.exe as I deleted
all Excel files I've found to date and allowed Office 2007 to reinstall Excel.

In previous versions of Excel, one could create macros that would modify
your startup and this is what I'm thinking is my issue here. I just don't
know all the external files Excel touches at startup.

JLatham said:
In Excel 2007, if there are custom menus created in earlier versions of
Excel, they show up on the Add-Ins tab.

I'd open up the VB Editor (press [Alt]+[F11]) and examine the project for
any VBA code that may be in it. Just start down the list - first see if
there are any code modules listed. Once you've dealt with any code modules
(you can just delete them, of course you lose that functionality),
double-click on the names of each worksheet in the project window to see if
they have any code associated with them, and do the same for the ThisWorkbook
object.

As you find VBA code you'll have to make judgement calls as to whether to
delete it or not. To "delete" the code in worksheets/ThisWorkbook, simply
select all of the text and delete it.

booismycat said:
Forgot to mention: I tried to Manage Add-Ins. There is nothing listed
associated with this issue.
I then added the ToolPak, Lookup Wizard, Solver, etc. They are listed in the
Manager but not on the Ribbon.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top