Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to diable save change at closing the workbook
Is it possible to disable The message you receive at closing and opening, to
save changes and to update file, because I've created a file just for printing bills where I do not need changes done on the page to be saved, just like there is no need for updates either. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to diable save change at closing the workbook
Shariq
You could include a workbook_beforeclose() event code as below. (To implement right click on the small Excel icon top left of the workbook and select view code...) Private Sub Workbook_BeforeClose(Cancel As Boolean) Me.Saved = True End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Shariq" wrote in message ... Is it possible to disable The message you receive at closing and opening, to save changes and to update file, because I've created a file just for printing bills where I do not need changes done on the page to be saved, just like there is no need for updates either. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change location of auto saved back up copy of shared workbook? | Excel Discussion (Misc queries) | |||
How do I save printing option for all in a shared Excel workbook? | Excel Worksheet Functions | |||
Change sheet reference in new workbook | Excel Discussion (Misc queries) | |||
i made change in a current workbook and accidentally save it, can. | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |