View Single Post
  #1   Report Post  
timg
 
Posts: n/a
Default 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.