| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem saving with VBA project protected.
I have an application in EXCEL 2003 which uses VBA. I have password
protected the VBA project but when I try to save it I get the following message: "Cannot save in this file format while VBA project is protected" I have other applications which I have protected and do not have this problem. Hopefully you can help me find the answer. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem saving with VBA project protected.
Unprotect the VBA. Hit File-Save as. What does the files of type say? If it
looks okay, better go to Tools-Options, Transition tab and check out what type of file it's being saved as. **************** Anne Troy www.piersontech.com www.mrexcel.com "JAMES T." wrote in message oups.com... I have an application in EXCEL 2003 which uses VBA. I have password protected the VBA project but when I try to save it I get the following message: "Cannot save in this file format while VBA project is protected" I have other applications which I have protected and do not have this problem. Hopefully you can help me find the answer. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem saving with VBA project protected.
What is the format you use when you're trying to save the workbook?
Manually, it's at the bottom of the File|SaveAs dialog. (It's not HTML stuff is it?) "JAMES T." wrote: I have an application in EXCEL 2003 which uses VBA. I have password protected the VBA project but when I try to save it I get the following message: "Cannot save in this file format while VBA project is protected" I have other applications which I have protected and do not have this problem. Hopefully you can help me find the answer. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem saving with VBA project protected.
The format under "save as" is "Microsoft Excel 97 - Excel 2003 & 50/95
workbook". |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem saving with VBA project protected.
xl95 didn't have the abilility to protect the project.
Is there a real reason you don't just use the "Microsoft Office Excel Workbook (*.xls)"? Xl97 through xl2003 will be able to read this file format. "JAMES T." wrote: The format under "save as" is "Microsoft Excel 97 - Excel 2003 & 50/95 workbook". -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem saving with VBA project protected.
My work computer is soon to be upgraded to MS Excel 2003. I will just
have to wait for the upgrade to protect the VBA. Thanks for your help. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem saving with VBA project protected.
If you're work computer is running xl95, then ignore this.
But if you're running xl97 (or greater) on all your pcs, then you can just save in the most current version. "JAMES T." wrote: My work computer is soon to be upgraded to MS Excel 2003. I will just have to wait for the upgrade to protect the VBA. Thanks for your help. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| protected project | Excel Discussion (Misc queries) | |||
| VBA project is protected | Excel Discussion (Misc queries) | |||
| Assigning the Help 4, *.HLP file for a project programmatically in a protected Project | Excel Programming | |||
| Accesing vba project from wb that has vba project password protected | Excel Programming | |||
| Saving a spreadsheet with a protected VBA project | Excel Programming | |||
Hybrid Mode
