macro

[chazzerman01]

does anyone know a macro code that will highlight the whole row that the cursor is on. im using it to make it easier to read values in a table

 

[chazzerman01]

Is it possible to make a macro so that whenever anyone opens the excel sheet, it displays a message box.

 

[My Aswer Is This]

Try this:

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Activate()
'Modified  11/28/2019  4:42:45 AM  EST
MsgBox "Hello World" & vbNewLine & "It is now" & vbNewLine & Now
End Sub

 

[KOKOSEK]

Come on. I did not say line above, I said above

 

[KOKOSEK]

Is it possible to make a macro so that whenever anyone opens the excel sheet, it displays a message box.

Open new thread, that's far, far away from original issue in this thread.