var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Event when i change active sheet
I need some help for a vba code.
I need to had some code when user selects a specific sheet. I have a workbook with 5 sheets, and i need to send a message when user is on sheet 1 and changes ( by bottom toolbar ) to sheet 2.
My problem is that i don't know which event is trigered when user do this kind of thing.
Could you help me?
Worksheet_Activate Events for the worksheet object occurs when a worksheet is activated or the user changes the content of a cell.
Right click on Sheet2 tab (by bottom toolbar ) and select "View Code" and then copy the following code
Private Sub Worksheet_Activate()
'Code by Muhammad Anisur Rahman
'Your code here
MsgBox "You Message here"
Originally Posted by vramalho