Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" wrote: 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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" wrote: 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" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need a product key for my Trail product, 2007 Microsoft Office s | Setting up and Configuration of Excel | |||
Use of Excel as part of a new product name | Excel Discussion (Misc queries) | |||
Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions |