Excel 2003 Error: You cannot save to this file format when the VBA project is protected.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Pullen - 18 Oct 2003 19:24 GMT

Error message when saving.

You cannot save to this file format when the VBA project is protected.
You may unprotect the VBA project by choosing the Properties command on the
Visual Basic Editor's Tools menu, and entering the password for the active
project.

What the heck is this? I can't protect a VBA project in a .xls file any
more?

Reply to this Message

Tom Ogilvy - 19 Oct 2003 03:59 GMT

Look in Tools=>Options=>Transition tab and see what your default file format
is.

I suspect you are trying to save in something other than Microsoft Excel
Workbook.

--
Regards,
Tom Ogilvy

> Error message when saving.
>
[quoted text clipped - 5 lines]
> What the heck is this? I can't protect a VBA project in a .xls file any
> more?

Reply to this Message

John Pullen - 19 Oct 2003 22:29 GMT

You're correct. Thanks very much.

Rather confusing that the "Microsoft Excel 97 - Excel 2003 & 5.0/95
Workbook" format couldn't handle that. Oh well.

> Look in Tools=>Options=>Transition tab and see what your default file format
> is.
[quoted text clipped - 16 lines]
> > What the heck is this? I can't protect a VBA project in a .xls file any
> > more?

Reply to this Message

jchan - 15 Jul 2006 06:56 GMT

What actually is the solution ?
How can we able to save the worksheets and protect the vba project for
viewing at the same time.

>You're correct. Thanks very much.
>
[quoted text clipped - 6 lines]
>> > What the heck is this? I can't protect a VBA project in a .xls file any
>> > more?

Reply to this Message

Rate this thread: