Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to prevent user to interrupt macro
As I have a macro manipulating hidden worksheets, I do not
want any user to being able to interrupt the macro, in order to get access to the hidden worksheets. Which code will prevent any interruption from the user? i try to use ON ERROR but it dosen't work thks in advance jerome |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to prevent user to interrupt macro
Jerome,
try using the Interactive proprty: Application.interactive = false But remember to turn it back on at the end of the macro, or you'll be stuck with an unresponsive spreadsheet! Application.interactive = true Cheers, Pete -----Original Message----- As I have a macro manipulating hidden worksheets, I do not want any user to being able to interrupt the macro, in order to get access to the hidden worksheets. Which code will prevent any interruption from the user? i try to use ON ERROR but it dosen't work thks in advance jerome . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to prevent user to interrupt macro
Interactive property does not work either. I can still use
Ctrl + Break or Esc to suspend execution. jerome -----Original Message----- Jerome, try using the Interactive proprty: Application.interactive = false But remember to turn it back on at the end of the macro, or you'll be stuck with an unresponsive spreadsheet! Application.interactive = true Cheers, Pete -----Original Message----- As I have a macro manipulating hidden worksheets, I do not want any user to being able to interrupt the macro, in order to get access to the hidden worksheets. Which code will prevent any interruption from the user? i try to use ON ERROR but it dosen't work thks in advance jerome . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent Tab from User Delete | Excel Worksheet Functions | |||
Prevent user from using Name | Excel Discussion (Misc queries) | |||
How to prevent user to copy excel file to their own pc | Excel Discussion (Misc queries) | |||
Prevent user from saving workbook | Excel Discussion (Misc queries) | |||
How to prevent user from printing in Excel? | Excel Discussion (Misc queries) |