Vba excel create event log

Private Sub Workbook_NewSheet(ByVal Sh As Object)
On Error Resume Next
Sh.Range("A1") = Format(Now, "dd-mmm-yyyy hh:mm:ss")
End Sub

Source: trumpexcel.com

Vba excel create event log

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then MsgBox "Save this File in the K Drive"
End Sub

Source: trumpexcel.com

Vba excel create event log

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Worksheets("Sheet1").Range("A1") = Format(Now, "dd-mmm-yyyy hh:mm:ss")
End Sub

Source: trumpexcel.com

Vba excel create event log

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
sh.Protect
Next sh
End Sub

Source: trumpexcel.com

Vba excel create event log

Private Sub Worksheet_Activate()
ActiveSheet.Unprotect
End Sub

Source: trumpexcel.com

Vba excel create event log

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    Application.Undo
    Application.EnableEvents = True
End Sub

Source: trumpexcel.com

Vba excel create event log

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
CurrFormat = Target.Font.Strikethrough
If CurrFormat Then
Target.Font.Strikethrough = False
Else
Target.Font.Strikethrough = True
End If
End Sub

Source: trumpexcel.com

Vba excel create event log

Sub MessageTime()
Application.OnTime TimeValue("14:00:00"), "ShowMessage"
End Sub

Sub ShowMessage()
MsgBox "It's Lunch Time"
End Sub

Source: trumpexcel.com

Vba excel create event log

Changes that do not trigger
	change the formatting of the cell (font size, color, border, etc.).
    merge cells. This is surprising as sometimes, merging cells also removes content from all the cells except the top-left one.
    add, delete, or edit a cell comment.
    sort a range of cells.
    use Goal Seek.
changes that do trigger the event
    Copy and pasting formatting
    Clearing formatting
    Running a spell
Private Sub Worksheet_Change(ByVal Target As Range)
	MsgBox "You just changed " & Target.Address
End Sub

Source: trumpexcel.com

Vba excel create event log

Dim NextRefresh as Date

Sub RefreshSheet()
ThisWorkbook.Worksheets("Sheet1").Calculate
NextRefresh = Now + TimeValue("00:05:00")
Application.OnTime NextRefresh, "RefreshSheet"
End Sub

Sub StopRefresh()
On Error Resume Next
Application.OnTime NextRefresh, "RefreshSheet", , False
End Sub

Source: trumpexcel.com

Similar codes

0 vote327 views1 answer
Vbscript check if string contains
VBA
0 vote345 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote326 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote321 views1 answer
Vbnet check if string is only symbols
VBA
1 vote326 views1 answer
Add a index column power bi
VBA
0 vote339 views1 answer
Convert number to minutes in vba
VBA
0 vote418 views1 answer
Excel vba delete columns in range
VBA
3 votes329 views1 answer
Excel vba change format of cell
VBA
0 vote351 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
5 votes345 views1 answer
Xl vba double quotes in string literal
VBA