Lockdown and protecting worksheet suggestions

  • Thread starter Thread starter AndyB
  • Start date Start date
A

AndyB

I have an Excel Workbook with many sheets and many many
lines of VBA Code to create live spreadsheets. Since the
cells are constantly changing to lock it down password
protect is limited. Once the sheets are protected live
update requires the cells to constantly unlock to change.
Any suggestions on locking it down so that the cells can
change via VB but not user manipulation in the cell
itself or any functions that will allow that?
 
Look at the UserInterfaceOnly argument to the Protect method. Setting this
to True will allow macros, but not general users, to change the locked
cells.
 
Back
Top