Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Is CHOOSESHEET.XLA Removed?
Installed it a while ago. Now would like to remove it as the spreadsheet has grown to 750 sheets and populating the CHOOSESHEET menu takes much longer than going to an Index sheet with links to each sheet. Tools | Addins | and deselecting CHOOSESHEET.XLA doesn't seem to do it as it still shows on the tool bar and in the IDE window. Clicking on it in the VBA Project Explorer Window prompts for a password. Clicking on the initial file installs a second icon on the tool bar. What is the trick? -- kghexce ------------------------------------------------------------------------ kghexce's Profile: http://www.excelforum.com/member.php...o&userid=29804 View this thread: http://www.excelforum.com/showthread...hreadid=499302 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Is CHOOSESHEET.XLA Removed?
Open excel
Make sure "choosesheet.xla" is loaded. open the VBE (alt-f11) hit ctrl-g to see the immediate window type this and hit enter: ?workbooks("choosesheet.xla").fullpath make a note of that location Close excel Find that workbook and move it somewhere else. === Restart excel try the tools|addins once more (to de-select it) You'll be prompted to remove it from the list, since excel can't find it. === If the addin was in your XLStart folder, then that could explain why the tools|addins attempt didn't work. kghexce wrote: Installed it a while ago. Now would like to remove it as the spreadsheet has grown to 750 sheets and populating the CHOOSESHEET menu takes much longer than going to an Index sheet with links to each sheet. Tools | Addins | and deselecting CHOOSESHEET.XLA doesn't seem to do it as it still shows on the tool bar and in the IDE window. Clicking on it in the VBA Project Explorer Window prompts for a password. Clicking on the initial file installs a second icon on the tool bar. What is the trick? -- kghexce ------------------------------------------------------------------------ kghexce's Profile: http://www.excelforum.com/member.php...o&userid=29804 View this thread: http://www.excelforum.com/showthread...hreadid=499302 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Is CHOOSESHEET.XLA Removed?
For some reason ?workbooks("choosesheet.xla").fullpath triggered "Run-time error 438. Object doesn't support this property or method." So I used Yahoo Desktop Search to find the file, renamed it, restarted Excel|Tools|Addins|ChooseSheet.XLA. As you predicted it is now just a memory. Thanks so much. -- kghexce ------------------------------------------------------------------------ kghexce's Profile: http://www.excelforum.com/member.php...o&userid=29804 View this thread: http://www.excelforum.com/showthread...hreadid=499302 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
Excel 2003 / Send To / Mail Recipient / body text is removed | Excel Discussion (Misc queries) | |||
Can't break a link, all links are removed | Excel Worksheet Functions | |||
Spreadsheet "buttons" that cannot be removed | Excel Discussion (Misc queries) | |||
Password cannot be removed | Excel Discussion (Misc queries) |