Default Cell Values & Save Changes Dialog Box
 

I have all but 2 cells locked and protected. I want other users to be able
to change the values in these 2 cells in order to view their effect on
various calculations. In addition, I'd like the workbook to do the following:

1. Not show the "Do you want to save changes?" dialog box, even though the
user might have changed one or both of the values within the 2 cells.

2. Maintain default values within the 2 cells for the next user who might
open the workbook, regardless of the final values the preceeding user entered.

--
Thanks and Regards, timg.

Default Cell Values & Save Changes Dialog Box
 

Works well, thanks tra
--
Regards, timg.


"tra" wrote:

Put the following code into the ThisWorkbook object in the Visual Basic
Editor:

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

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Cancel = True
End Sub

The first Sub prevents the "Do you want to save changes?" dialog box
from showing when the workbook is closed
The second Sub prevents the user from saving any changes.

Note, however, that if the user opens the workbook without enabling
macros, then they will get the "Do you want to save changes?" dialog
box and they will be able to save it.