Hi!
I need to create a macro that force you to press a button before you leave the sheet. Is it possible?
Thanks in advance!
Hi!
I need to create a macro that force you to press a button before you leave the sheet. Is it possible?
Thanks in advance!
Hi !
Maybe using Worksheet_Deactivate event …
I have already tried with that command and it is not possible, error
Error just means a bad code, no that is not possible !
You have a point!
Sub Button1_Click() Sheet1.Activate End Sub Private Sub Worksheet_Deactivate() If IsError(Application.Caller) Then Me.Activate Else If Application.Caller <> "Button 1" Then Me.Activate End Sub
Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks