How do I get Excel to stop publishing?
I want my Excel file to go back to normal. I can't stop it from publishing
every time I save my file. |
How do I get Excel to stop publishing?
I would suspect that there is a "before save" macro somewhere in your
workbook that is sending a print command when you do a save. Check your ThisWorkbook code module for the most obvious place. If not there, then I don't know. "Darkenmoor" wrote: I want my Excel file to go back to normal. I can't stop it from publishing every time I save my file. |
How do I get Excel to stop publishing?
All I know is when I saved the file as a web page, republishing was an option
given as a check box. Seems like there would be a place to turn it off. What if I decided not to publish? Is microsoft really expecting me just to throw the file away and start again? Somethings not right here. Thanks! Any other ideas? David "JLGWhiz" wrote: I would suspect that there is a "before save" macro somewhere in your workbook that is sending a print command when you do a save. Check your ThisWorkbook code module for the most obvious place. If not there, then I don't know. "Darkenmoor" wrote: I want my Excel file to go back to normal. I can't stop it from publishing every time I save my file. |
How do I get Excel to stop publishing?
I have yet to find an off switch either; however, I do know of a work around.
Open the file in question, then start a brand new workbook. Copy everything from the old work book into the new workbook. Close the old workbook (no need to save). Then save the New Workbook as the Old one. This will bring all data as well as database connections over and strip any excess coding such as Print Formatting, Publishing, Column & Row sizes. Then delete any published versions you don't want. HTH, Rich Webb "Darkenmoor" wrote: All I know is when I saved the file as a web page, republishing was an option given as a check box. Seems like there would be a place to turn it off. What if I decided not to publish? Is microsoft really expecting me just to throw the file away and start again? Somethings not right here. Thanks! Any other ideas? David "JLGWhiz" wrote: I would suspect that there is a "before save" macro somewhere in your workbook that is sending a print command when you do a save. Check your ThisWorkbook code module for the most obvious place. If not there, then I don't know. "Darkenmoor" wrote: I want my Excel file to go back to normal. I can't stop it from publishing every time I save my file. |
All times are GMT +1. The time now is 02:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com