Lockdown and protecting 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?
 
Answered your other identical post in worksheet.functions. Please don't
multipost!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lockdown and protecting worksheet suggestions 2
lockdown a workbook 2
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Password Cell Protection 1
VBA Protect and NOT be able to selct locked cells 2
Protecting worksheet. 1
Cursor and Sheet Protection may09 2
Modifying a locked/protected sheet 3

Back
Top