Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In Word, I have created a couple helpful macros and placed
them on the toolbar with an icon. The piggybank will close the open document and save all changes. The garbage can will close the document and NOT save any changes. This precludes me having to respond to the "do you want to save changes?" prompt each time (annoying!). They work slick in Word. Now, I'd like to have the same feature in Excel, but the macro design or language is different and I can't figure it out. Here's the simple one-line of code for the "close no save" macro (in Word): ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges What would be the equivilent in Excel? Thanks in advance. Jerry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? | Excel Discussion (Misc queries) | |||
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? | Excel Worksheet Functions | |||
Need a "save & close" button directly on spreadsheet | Excel Discussion (Misc queries) | |||
Disable "Save" &/or "Close" | Excel Programming | |||
How can I get "File Close" to prompt me to "Save Changes" ?? | Excel Programming |