View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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!