Need Help Removing a Project in VB Please

T

TomP

I'm having trouble modify a file that is already in template form and want to
remove some VB codes and bookmarks. The macro runs fine until "magically"
the old bookmarks returned to the screen. It just won't go away. I looked
in the VB Editor there were two projects (Old one and New one). I
right-click the project that I want to get rid of and noticed that the
"Remove" button is grayed out. I'm stuck. :-(

Thank you for your help!

Tom
 
J

Jonathan West

TomP said:
I'm having trouble modify a file that is already in template form and want
to
remove some VB codes and bookmarks. The macro runs fine until
"magically"
the old bookmarks returned to the screen. It just won't go away. I
looked
in the VB Editor there were two projects (Old one and New one). I
right-click the project that I want to get rid of and noticed that the
"Remove" button is grayed out. I'm stuck. :-(

Create a new document based on the template, and save that document as a
template. All the VB code will be gone from it. You can then choose to
re-import as much or as little of the VB as you wish.

Also be aware that you can only edit a VBA project if the document
containing it is either

1. normal.dot, or
2. Open in an editing window, or
3. The attached template of a document open in an editing window.

You can't edit the VBA project of a template merely loaded as an add-in.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top