I tried to re-create your situation with no success. Could there be links in
the web copy, linked back to the xls copy?
--
Best wishes,

Jim


"Lumpjaw" wrote:

Thanks David for the suggestion, unfortunatly in this case there is no code
for the workbook in any case. The way I did this was like this.

I saved my spreadsheet as a regular Excel doc, than I saved it as a single
web page. Now when I open the file and save, it is save in both formats in
two locations. Any other suggestions? thank.

-lumpjaw

"dkinn" wrote:

check out the beforesave event of this workbook.

press Alt+F11
double click on ThisWorkbook and in the code window make sure Workbook is
selected in the left dropdown and then in the right dropdown look for
BeforeSave (or any other in the list that is in bold type) and see what code
shows. You should see the code for saving in both types there and you can
remove the one you don't need ( or just put an ' in front of the line of code
to comment it out )

David

"Jim Jackson" wrote:

Look for a "Sub Auto_Close()" macro in the modules.

It should have the code lines there that you want to remove.
--
Best wishes,

Jim


"Lumpjaw" wrote:

I have an Excel spreadsheet that saves in two different formats when you
click save. One is as a webpage the other is just as Excel. How do I remove
the saving as a webpage? Thanks.