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.
 

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 suggestions 2
lockdown a workbook 2
Protecting Cells In A Worksheet 1
I can still select & manipulate locked & protected cells in '07 1
Multi worksheet protection & editing ability 6
protect worksheet but allow row deletion 3
Protecting worksheet 1
Change cell color in protected sheet 1

Back
Top