Solved

Remove erroneous worksheets/code from VBA Editor

Posted on 2016-07-25
6
30 Views
Last Modified: 2016-07-26
Looking for a method/addins that will clean up my vba, removing all erroneous codes and sheets that are still visible in VBA Editor, however, no longer exists in the workbook.  (ie ThisWorkbook1, thisWorkbook2)
0
Comment
Question by:Karen Schaefer
  • 2
  • 2
  • 2
6 Comments
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
Did you try quitting and restarting Excel?
0
 

Author Comment

by:Karen Schaefer
Comment Utility
yes and stays there.  I know this has been an issue in the past, and I have seen some addins that can be used, unfortunately I am unable to download these to my work system - do not have admin rights
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
Can you attach your workbook?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 2

Accepted Solution

by:
Simulog earned 500 total points
Comment Utility
I had this issue a few years back, any time the workbook had been with a colleague who had a corrupt Excel installation.

Back then the solution was to save as Excel95 - close - open - save as Excel2003. This meant that you loosed some stuff from Excel2003

The modernized version would be to export all VBA, save the workbook as an XLSX (no macros), open it, import back all VBA and save it as an XLAM again.

Good Luck
0
 
LVL 2

Expert Comment

by:Simulog
Comment Utility
Sorry, the last should obviously be "save as an XLSM again".
0
 

Author Closing Comment

by:Karen Schaefer
Comment Utility
Thanks that did the trick.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now