Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-04-2017, 02:34 PM
genpromo genpromo is offline VBA Unprotect Input Date By Offset Windows 10 VBA Unprotect Input Date By Offset Office 2010 32bit
Novice
VBA Unprotect Input Date By Offset
 
Join Date: May 2017
Posts: 3
genpromo is on a distinguished road
Default VBA Unprotect Input Date By Offset

Please need help to solve the programming :
unprotect sheet if the cell is selected and protect sheet again after the run vba completed.
The column 2 is for the input "IN" and protect the column 4, but if I insert command "Sheet1.Unprotect" then the Vba won't work.

Quote:
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Cells.count = 1 Then
If .column = 2 And .Row > 1 And .Value = "In" Then


.Offset(, 2).Value = Format(Now(), "dd/mm hh:mm:ss")
End If
If .column = 3 And .Row > 1 And .Value = "Out" Then
.Offset(, 2).Value = Format(Now(), "dd/mm hh:mm:ss")
End If
End If

End With

End Sub
Any help will be very much appreciated.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Unprotect Cells Cardinal2 Excel Programming 2 01-06-2015 05:15 PM
VBA Unprotect Input Date By Offset Set offset properties of a picture charm PowerPoint 1 11-01-2014 05:41 AM
VBA Unprotect Input Date By Offset Formula In Excel To Prompt User To Input Date pclutts Excel Programming 4 08-31-2014 12:45 PM
VBA Unprotect Input Date By Offset Syntax to use OFFSET() in a cell formula? dlowrey Excel 3 07-09-2013 09:15 AM
ADD in That can unprotect the documents. aligahk06 Word 0 07-12-2010 04:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft