best way protect unprotected cells

  • Thread starter Thread starter oldyork90
  • Start date Start date
O

oldyork90

forget buttons.... don't even suggest them.

I have a list/table of names. The user selects a cell to update a chart display for that person. Works great... but

How can you protect the cell from the user inadvertently changing the value in that cell? If he can select it, he can nuke it. I don't want STEVE JOHNSON turning into STEVE JOHNSONX or ...

Thank you.
 
forget buttons.... don't even suggest them.



I have a list/table of names. The user selects a cell to update a chart display for that person. Works great... but



How can you protect the cell from the user inadvertently changing the value in that cell? If he can select it, he can nuke it. I don't want STEVE JOHNSON turning into STEVE JOHNSONX or ...



Thank you.
Click to expand...

If you have macros enabled when the workbook opens, you can create a worksheet change macro that checks the cell address and if the user is allowed to change, it permits. Otherwise it tells the user to do an undo.

Robert Flanagan
Add-ins.com LLC
Phone: 302-234-9857, fax 302-234-9859
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Back
Top