cell protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to protect some cells from user input, but need to changes the values
of these cells via code. How can I do this?

Sheldon
 
Hi Sheldon.

Protect the worksheet, setting the UserInterfaceOnly argument to true. This
argument is not persistent, so you could reset it in the Workbook_Open
event.

The UserInterfaceOnly argument will permit code manipulation of the locked
cells on the protected sheet.
 
You must log in or register to reply here.

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

best way protect unprotected cells 2
Returned position address on protected sheet 7
Protecting cell contents 3
macro to set cell protection by row, based on pre-populated values 3
VBA set thick borders around non empty cells in range 0
Allow VBA code to change a locked cell?? 2
Windows 7 Autofit row heights of merged cells in protected worksheet 0
VBA code to protect cells Outside a given range 2

Back
Top