View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Warning when saving in Excel 03 running on XP

I wouldn't have held back if I did have any. Sorry.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

the warning is still showing, any other ideas?

"Tom Ogilvy" wrote:

No. That should be an application level setting.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

It is at "Microsoft Office Excel Workbook" for the sheet i am working in.
However, i have around 15 sheets, do I have to check every sheet in the
workbook?

"Tom Ogilvy" wrote:

Look in Tools=Options in the Transition tab and see what the setting is for
the default format for the "Save Excel Files As:" dropdown.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

I am doing some corrections to an Excel file that my company has created. The
file has a lot of security attached to it, including RMS from MS. When I save
the file, I get an error that reads A sheet in the workbook you are trying
to save is password protected. Password protected sheets cannot be saved in a
Web Page. To save this file as a Web Page, you must first remove the
password. This warning just started to show up Yesterday. (7/16/2007) The
problem is I do not want the sheets to be saved as a Web Page. I do have
about fifteen password protected sheets that I just what to save as an Excel
file. Does anyone know why it is trying to save the file this way? This
warning comes up every time that I save the file and also when the computer
does an auto save. As of now, I am saving some sheets with passwords and some
sheets without, when I am finished with the file all sheets will be password
protected. I also had a password to open the file, but until I am finished I
have also removed the password for easier access until I am finished. When I
am finished I will be adding a password to open the file.