Can't save in Excel

N

nexxas

We have a macro that opens Excel and downloads data to a
worksheet. When trying to save the data it comes up with
this message:
"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
above project."

This macro was written on a PC running Win 2K SP4 & Office
2K SP3.
The error appeared on a PC running Win XP SP1 & Office XP
SP2.

We don't want to unprotect the project because the macro
is used by our customers and they don't need to dink with
the code, if ya know what I mean!

Thanx for any input!
 

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