Thread: 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.

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.
>
>