Allow access to cell but don't change cells formula

  • Thread starter Thread starter clayton
  • Start date Start date
C

clayton

Ok, here's one more for ya...

I have my sheet password protected but I am allowing access to certai
fields that have formulas in them.
For example, If they select a vendor from a list it will populate
cell by means of vlookup. There are times when they may need to chang
an address or contact name so I am allowing access to those cells. Her
is my problem... After they have changed those cells what is stopin
them from pressing the save button which will overwrite my formulas? I
the a VB way to avoid this?

I have the following which stops them from using the SaveAs.
Can this be modified to work with the save option too?

'Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel A
Boolean)

If SaveAsUI = True Then
MsgBox "I'm Sorry, Per QS 9000 we can only have one copy of this form
Sorry, No exceptions."
Cancel = True
Exit Sub
End If

End Su
 
Back
Top