×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Getting rid of Macros
3

Getting rid of Macros

Getting rid of Macros

(OP)
Hi folks,
I wonder if you can help with a problem I'm having with Excel.
I  have a spreadsheet that I created some macros in to help me with the development stage of an application. I then deleted all the macros but when I open the file it still asks me if I wants to run macros, even though there are none there.
I want to solve this before I send it out, can anyone help?

Cheers...

RE: Getting rid of Macros

Best advis I had in this forum was to downlad ASAP from here:
http://www.asap-utilities.com/
The remove macros/vba command might do it.

JMW
www.viscoanalyser.com
Eng-Tips: Pro bono publico, by engineers, for engineers.

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips Fora.

RE: Getting rid of Macros

you can copy your file sheet by sheet into a new excel file and delete the old one, it worked for me.

RE: Getting rid of Macros

Deaks,

I've had a similar problem with the macro warning after deleting all the macros and I believe it is related to the creation of a "Modules" folder when you create macros.

Try this,
1. Open the offending workbook, let's call it Book1.
2. Select from the menu Tools\Macro\Visual Basic Editor (Alt+F11)
3. In the Visual Basic Editor, select View\Project Explorer (Ctrl+R)
4. In the section of the screen listing your folders, look for the category VBAProject (Book1) where Book1 is the offending workbook name.
You may find you have a Modules folder with a Module1 item.  Check to see Module1 is empty and delete it.  That should prevent the macro warning message the next time you open.

RE: Getting rid of Macros

Please see the FAQ in this forum.
FAQ770-48

--Scott

For some pleasure reading, try FAQ731-376

RE: Getting rid of Macros

Now, if that is not a classic example of re-inventing the wheel...  all this time, and the answer was right there in the FAQs.  Obviously pays to check the FAQs.  Good FAQ, Swertel!

RE: Getting rid of Macros

(OP)
Thanks for the replies people. Hopefully the stars and the "Good" rating will make up for my poor etiquette...
Ian

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources