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" wrote in message
...
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?

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?

"Hargrove" wrote:

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?

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" wrote in message
...
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?

"Hargrove" wrote:

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?