Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a spreadsheet with a protected VBA project
Good Day to all...
We have software, which is really a macro running in Excel, that is used with data logging instruments. In 2 instances out of hundreds of users there has been an issue with saving the spreadsheet after downloading the data into it. It is the following: "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." Unprotecting the project is not an option! I have not been successful in re-creating this problem myself. The same program is used, data downloaded into it and saved without any issues. All flavors of Windows OS's & Office's have been used in many different configurations. I'm at a loss trying to explain this one and have been unsuccessful in finding an answer in the Knowledge Base or in any of the newsgroups. Any help &/ suggestions would be greatly appreciated!! Thanx All! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a spreadsheet with a protected VBA project
A guess -
On the problematic machines, look in Tools=Options = Transition tab and make sure the default format for saving is Workbook. Save Excel Files As: Microsoft Excel Workbook -- Regards, Tom Ogilvy "Nexxas" wrote in message ... Good Day to all... We have software, which is really a macro running in Excel, that is used with data logging instruments. In 2 instances out of hundreds of users there has been an issue with saving the spreadsheet after downloading the data into it. It is the following: "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." Unprotecting the project is not an option! I have not been successful in re-creating this problem myself. The same program is used, data downloaded into it and saved without any issues. All flavors of Windows OS's & Office's have been used in many different configurations. I'm at a loss trying to explain this one and have been unsuccessful in finding an answer in the Knowledge Base or in any of the newsgroups. Any help &/ suggestions would be greatly appreciated!! Thanx All! |
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) | |||
Password protected VBA project | New Users to Excel | |||
replace line of code in vba protected project | Excel Programming | |||
Loading Add-ins to a Protected Project | Excel Programming |