| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Mouse During Macro
I am sending information from Access to Excel. I want to keep the Excel
application visible so that the user can see what's going on. However, they can click on it and the code gets disrupted. Is there any way to temporarily turn off the mouse and keyboard while the application is running? The code is all in an Access module. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Mouse During Macro
Application.Interactive = False
but see the help on this function for cautions. -- Regards, Tom Ogilvy "Rod" wrote: I am sending information from Access to Excel. I want to keep the Excel application visible so that the user can see what's going on. However, they can click on it and the code gets disrupted. Is there any way to temporarily turn off the mouse and keyboard while the application is running? The code is all in an Access module. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Mouse During Macro
I can't find any help reference to it but it works. Thanks!
"Tom Ogilvy" wrote: Application.Interactive = False but see the help on this function for cautions. -- Regards, Tom Ogilvy "Rod" wrote: I am sending information from Access to Excel. I want to keep the Excel application visible so that the user can see what's going on. However, they can click on it and the code gets disrupted. Is there any way to temporarily turn off the mouse and keyboard while the application is running? The code is all in an Access module. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| disable right click on mouse | Excel Discussion (Misc queries) | |||
| Disable mouse? | Excel Programming | |||
| Disable sheets tabs right mouse button! | Excel Programming | |||
| Disable the right mouse button?? | Excel Programming | |||
| disable keyboard/mouse from vba for all programs? | Excel Programming | |||
Linear Mode
