View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Save as problem for Excel 97/2000 (with VBA-protection in excel 20

Just save it as a regular workbook.
If you have code that doesn't work in XL 2000, then saving it
as an earlier version will not fix the code. It will still not work.

You will still be able to unprotect and work on the code in XL2000,
but not in XL97 versions.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Cheetahke"
wrote in message
Hi all
When I've protected VBA with a password, and I want to save my workbook as
an Excel 97/2000 workbook, I get an error message that's saying that I must
"unprotect" the VBA-code before saving the workbook. I've written the code
with excel 2003.
How can I save as an excel 97/2000 workbook without unprotecting the
VBA-code? I need to do this for working with it in Excel 2000.