LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default Time stamp function trouble shooting

I have the following function code that I wrote into a sheet that is supposed
to time stamp when a user selects "Y" from a drop down menu in a nearby cell.
The issue is that from time to time, for reasons I do not know, the function
ceases to work. What happens is that a run-time error pops up while a user
is dragging rows down in another par of the sheet, or something akin to this,
and then the sheet remains unprotected with the function disabled. Then I
can no longer get the function to activate again. Any suggestions on how to
improve upon this code?

Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False

With Worksheets("Administrator")
.Unprotect Password:="dist"
End With

If (Target.Row = 13 And Target.Column = 3 And Target = "Y") Then
ActiveSheet.Cells(16, 3) = Format(Now(), "mmm dd, yyyy h:mm AMPM;@")
End If

With Worksheets("Administrator")
.Protect Password:="dist"
End With

Application.EnableEvents = True

End Sub
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble shooting Edit/Replace with in a formula JessieB Excel Discussion (Misc queries) 3 January 3rd 08 09:58 PM
Trouble shooting Excel? meersr Excel Discussion (Misc queries) 1 April 15th 06 08:09 PM
Trouble shooting#NA error in Array formula RonR Excel Discussion (Misc queries) 2 June 14th 05 09:58 PM
trouble shooting section danielle Excel Discussion (Misc queries) 1 April 25th 05 10:11 PM
Excel trouble shooting - no gridlines Stumped Excel Discussion (Misc queries) 11 January 12th 05 10:40 PM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"