Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to Publishing | Excel Discussion (Misc queries) | |||
How do I STOP automatic publishing to web | Excel Discussion (Misc queries) | |||
how do you stop Excel from publishing web pages after you save | Excel Discussion (Misc queries) | |||
Publishing Excel through IIS | Excel Discussion (Misc queries) | |||
Web Publishing from Excel | Excel Discussion (Misc queries) |