Remove Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having difficutly removing a macro. I've tried going into the Project Explorer and selecting my VBA Project, but I receive the following message:
"Project Locked"
"Project Unviewable"
But everytime I open the file, it asks if I want to enable/disable the macros contained in the file. Any suggestions?
 
sounds like the project was protected in a later version of excel.

You would have to use the same version or later to unlock it.

--

Regards,
Tom Ogilvy

Hargrove said:
I'm having difficutly removing a macro. I've tried going into the Project
Click to expand...
Explorer and selecting my VBA Project, but I receive the following message:
"Project Locked"
"Project Unviewable"
But everytime I open the file, it asks if I want to enable/disable the
Click to expand...
macros contained in the file. Any suggestions?
 
It's possible that one of the other users has a older version. It's possible that they saved it in an older version as some point. However, I don't think we've ever protected the workbook. Is this the same thing as protecting the project?
 
No. Protecting the workbook is done in Tools=>Protection=>Protect Workbook

Protecting the project is done in the VBE under Tools=>VBA Project Name
Properties

--
Regards,
Tom Ogilvy

Hargrove said:
It's possible that one of the other users has a older version. It's
Click to expand...
possible that they saved it in an older version as some point. However, I
don't think we've ever protected the workbook. Is this the same thing as
protecting the project?Project Explorer and selecting my VBA Project, but I receive the following
message:macros contained in the file. Any suggestions?
 
Back
Top