-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cancel macro
-
Inputbox (Dim as string, can be blank) on Cancel
I've tried looking this up, but can't find a comparable problem with cancelling at an inputbox. I've got an inputbox that is looking for a text entry, but the odd one out here is that it can left blank at the entry point (if they don't want to filter a list). My problem is trying to get the...- melodramatic
- Thread
- cancel inputbox cancel macro
- Replies: 5
- Forum: Excel Questions
-
J
Action A Macro on enter in a worksheet
Hi I have a list of dates for product to be dispatched in column B and I'm trying to get the date beside in column C for the start of production (10 days before dispatch date). This works fine while I am using Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) but...- J Scene
- Thread
- cancel cancel macro dim enter key range
- Replies: 2
- Forum: Excel Questions
-
D
Application.EnableCancelKey=xlDisabled Not Working - Able To Cancel Save via Esc Key!
I'm trying to use Application.EnableCancelKey = xlDisabled so that when I save the workbook via VBA within the Before Close sub of the workbook module the user is not able to abort the save. In my (large) production workbook: This fails more often than not and pressing the 'esc' key a few...- davidnash
- Thread
- cancel macro disable keys enablecancelkey escape key interrupt macro
- Replies: 2
- Forum: Excel Questions
