How can I make a workbook close without prompting to save?
This file has many links to other workbooks, and it has many viewers.
Thanks
How can I make a workbook close without prompting to save?
This file has many links to other workbooks, and it has many viewers.
Thanks
I take it that you do NOT want changes saved. If that's right, enter
this code in the ThisWorkbook module. James
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub
DRANDON wrote:
> How can I make a workbook close without prompting to save?
> This file has many links to other workbooks, and it has many viewers.
>
> Thanks
>
>
> --
> DRANDON
> ------------------------------------------------------------------------
> DRANDON's Profile: http://www.excelforum.com/member.php...o&userid=35901
> View this thread: http://www.excelforum.com/showthread...hreadid=566107
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks