Macro to insert Current Time into protected cell

  • Thread starter Thread starter chortler
  • Start date Start date
C

chortler

I'm trying to create a time sheet and I want to have a macro insert the
current time into a protected cell (to stop people editing the time
manually)
Is this possible?? Any tips/hints
 
One way is to unprotect the sheet in the code (password = ron)

ActiveSheet.Unprotect "ron"
Range("C10").Value = Format(Time, "hh mm ss")
ActiveSheet.Protect "ron"
 
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

Macro entering data into a protected Cell?? 1
PROTECT MACRO IN NEW WORKBOOK 1
Excel Excel - Macro to Insert Cell 0
Macro to insert row in protected sheet 6
Insert character in a cell using a keyboard shortcut 10
Multiple Worksheets Protection 1
Insert Row also adds formulas and moves cursor 2
code for Allow Insert Hyperlink 2

Back
Top