Solved

Is there a VBA Code Cleaner for Excel 2004 for Mac?

Posted on 2011-02-10
13
572 Views
Last Modified: 2013-12-21
I am trying to remove a hidden macro from excel.  There's no macros listed, there's no hidden sheets, I've removed the VBA module, I've removed the sheet code for "this worksheet" (also started doing this individually on each worksheet - but I have over 100 and so far all but 2 are blank), Ctrl+F11 just adds another macro sheet,  and I've downloaded Ron Bovey's VBA Code Cleaner -- but it's an .exe which Mac doesn't execute.  But my spreadsheet still asks if I want to disable my macro when I open it.  Any more ideas?
0
Comment
Question by:melissa61
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +1
13 Comments
 

Author Comment

by:melissa61
ID: 34867925
By the way, this all started when I added a module for Patricks UDF "GetVals".  At first it worked great, but after closing and re-opening my spreadsheet, it became extremely unstable and would crash excel every time.  Now I'm trying to backtrack.
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 34878511
Follow the steps in this link.  These steps apply to all excel worksheets, whether it is for windows or for the MAC.
          http://forum.soft32.com/mac/Find-Delete-Macro-workbook-ftopict83451.html
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 34878541
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34878819
melissa61: I believe you have an empty module and hence you are getting that prompt. Delete that module and everything will be okay.

If it doesn't help then upload your workbook. I have a MAC and I can test it for you.

Sid
0
 

Author Comment

by:melissa61
ID: 34880568
Thank you for the replies, but I still haven't found the solution.  I have already followed links posted on this subject and have tried everything posted including deleting my code module.  The only thing I haven't done completely is go through each individual sheet code module to see if there is code.  I have a large spreadsheet with about 120 sheets, and I've checked about 50 of them - 2 had code which I erased.  This process is extremely tedious.  The best solution I had found in previous links is a "VBA Code Cleaner."  Is there such a thing for Excel for Mac???

Sid, thanks for the offer to upload my workbook -- it contains all my personal financial information, so I don't want to upload it over the internet.  Is there another way?

I would really love to try a VBA Code Cleaner -- does anybody know of one that will run on a Mac?
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34882335
melissa61: Can you post a screenshot of your vba editor?

Sid
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 34882651
Did you use Rob Bovey's latest version....Version 5.0? If not, see this link:
              http://apps-pro.com/Utilities/CodeCleaner.htm

If the above doesn't help, you should try doing the MAC equivalent of the Windows control panel repair suggested below:
Hi Nobler, we fixed it by doing a repair of Office from control panel so that it forced a re-register of the COM classes (which re-install didn't do?). If you go to Control Panel and then to "Add or Remove Programs" (I'm in Windows XP) and then click on Office and select repair when you run the installer. Also, it's never a bad thing to cut and paste the code from the offending VBA module into a new one and then delete the old one.
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 34883008
also see this link to download Microsoft's free vba code cleaner for Excel:
          http://excel-vba-code-cleaner.software.informer.com/
0
 

Accepted Solution

by:
melissa61 earned 0 total points
ID: 34883701
Microsoft's free vba cleaner says "You cannot use...with this version of Mac OS X."

I have finally made my way through each of the 122 individual VBA sheets and found the one that had code.  After deleting, that has fixed my issue.

Thanks
0
 
LVL 50
ID: 35221080
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

617 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