Module updating of Protected Cells

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

Guest

Is it possible to have a cell updated using a VBA module while the cell is
protected? I have a module that inputs the date/time in a field when a user
inputs information into another field. I want to protect the date/time so
that the user can not alter it. I am using Excel 2003.

Thanks for the help.
 
Hi

no, you'll need to unprotect the sheet, undate the cell and then re-protect
the sheet - this can all be done in code
e.g.

activesheet.unprotect "pwd"
'your code here
activesheet.protect "pwd"

use your password instead of pwd or delete if not required

Cheers
JulieD
 
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

Can a Macro override sheet Protection? 6
Attempted edit of protected cell jumps user to another cell 2
Can I protect data in a cell, but allow comments to be entered. 6
Changing font color of protected cells programatically 6
Excel Protection 2
Protect Cells 2
Visual Basic Protection and Delete Modules 3
Inserting Picture Into Protected Worksheet 1

Back
Top