Remove Macro

[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?

 

[Tom Ogilvy]

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

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?

 

[Guest]

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?

 

[Tom Ogilvy]

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

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?Project Explorer and selecting my VBA Project, but I receive the following
message:macros contained in the file. Any suggestions?