View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default Add-Ins - Go To Product - Part Duo

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" wrote:

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.