I would like to prevent the user from leaving Sheet1 if certain conditions are not met.
I'm using the Worksheet_Deactivate event in the Sheet1 module. However, when the user attempts to leave Sheet1 by selecting Sheet2, the Sheet2 Worksheet_Activate event runs even though I have...
Hi
I have a cell (D45) where if the value exceeds 12, a dialogue box appears when worksheet_deactivate. Works fine, but if the cell is not amended then the message box comes up every subsequent time there is worksheet_deactivate. Can I specify that the box appears a maximum number of...
Greetings,
When running the code below in a new workbook, with Sheet1 activated and with application.enableevents=True, the PasteSpecial line causes the Sheet1 and Sheet2 Worksheet_Activate codes to run (as well as their respective Worksheet_Deactivate events. Moreover, when the pastespecial...
Hi Folks
I have the following code that basically does not allow someone to leave the sheet they are on unless all required field are complete. It works perfect for my needs
My question is is it possible to have more than one worksheet_deactivate say for Range A2 with a different message...
I have a worksheet ("WS1") with a Worksheet_Deactivate procedure.
We have come across the following curious situation: When we navigate from WS1 to certain (but not all) other worksheets within our application, the Worksheet_Deactivate only fires every other time. This means that if we...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.