Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2006

Tip: Looking for answers? Try searching our database.

fix old file created with an old version of excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PiPPo - 29 Apr 2006 15:45 GMT
I have a workbook that I have inherited from a previous employee.  I
believe that it was created with an old version of Excel, or even with
Lotus 123.  Basically, I have a few sheets containing what seems to be
the code for macros (they in fact appear under the tools>macro>macros
menu).  Since they do not work, and since I have more or less an idea
of what they do, I decided to erase them and create my own macros.  If
I erase the sheets containing the code, I cannot erase the name of the
macros under the macros menu. Neither is possible to erase the names
from the macros menu.

Can someone tell me how to get rid of this old code?  Also, If I
activate the visual basic editor, there is not track of the
spreadsheet.

Thanks,

PiPPo
Gilles Desjardins - 30 Apr 2006 03:20 GMT
Question: When you click on Window, Unhide, is there a Personal.xls in the
available selection?
If yes, your macros are contained in this file. Use the VBA editor to reach
the module that contains the macro IN Personal.xls and delete. Once you are
finished, HIDE Personal.xls by going to Window, Hide.

HTH
Gilles
>I have a workbook that I have inherited from a previous employee.  I
> believe that it was created with an old version of Excel, or even with
[quoted text clipped - 13 lines]
>
> PiPPo
Gord Dibben - 30 Apr 2006 18:44 GMT
PiPPo

If the workbook in question was constructed using XL95 which had the "Menu
Editor" feature the Menu Items will continue to reappear even though there are
no Macros associated with them.  This feature(Menu Editor)was dumped with XL97
and up.
Jim Rech has written RemoveMenu.XLA which gets rid of these.  Can be found on
Stephen Bullen's site.

http://www.oaltd.co.uk/MVP/Default.htm

Gord Dibben  MS Excel MVP

>Question: When you click on Window, Unhide, is there a Personal.xls in the
>available selection?
[quoted text clipped - 21 lines]
>>
>> PiPPo
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.