Hi, I tried searching the group, but didn't find anything matching my
problem. It seems like something that would've been noticed before,
but maybe I'm just not using the right search terms. This isn't a
huge concern, but I'd like to know if I'm misunderstanding something
about how VBA works, as I'm pretty new to it. Thanks in advance!


I have a file (forms.xls) that I want to be able to open on a
keypress, so I've added a macro bound to Ctrl+Shift+F that just opens
forms.xls. This file is a series of data entry forms that I have to
print out, but not save (travel reimbursements, check requests,
etc.). Since I got tired of telling Excel that I don't want to save
changes, I added the following code to ThisWorkbook:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Sub

While this works perfectly when I open the file normally, for some
reason the "Do you want to save changes?" box appears if I've opened
the file using Ctrl+Shift+F. Why is this, and is there any way to get
rid of it for this file?

Thanks again.

--DanC