Allow access to cell but don't change cells formula
 

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

--
Message posted from http://www.ExcelForum.com

Allow access to cell but don't change cells formula
 

I solved the problem by hiding the toolbar and command bars. Thats good
enough for me :D


---
Message posted from http://www.ExcelForum.com/