Saving workbook with protected (hidden) VBA code

[Chris Meacher]

Whenever I try and save a workbook with my VBA code hidden
in Excel XP (2002 SP2) I get the random message:
"You cannot save to this file format when the VBA project
is protected."
"You may unprotect the VBA by choosing the Properties
command onthe Visual Basic Editor's Tools menu, and
entering the password for the active project."

The point is there's a bloody good reason I don't want the
code tampered with.

Surely there must be a way round this.

I have tried saving in all XL native formats with no
success, any more ideas?

Cheers

Chris

 

[Kim Mitchell]

Put your code in your personal macro workbook, not in the shared workbook.
That way, you can use the code on the workbook but it won't be available to
others. HTH

Kim