| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
??Programmatically set security level to medium
Using Excel 2000, can I programmatically set the macrossecurity setting to
medium on open? Hunted high and low (pardon the pun) but can't seem to find anything that specifically says "no", although "yes" hasn't really come up either! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
??Programmatically set security level to medium
"DG" wrote...
Using Excel 2000, can I programmatically set the macrossecurity setting to medium on open? Hunted high and low (pardon the pun) but can't seem to find anything that specifically says "no", although "yes" hasn't really come up either! For anything that can be done interactively, try doing it while the macro recorder is on. You'll see it doesn't record anything, so the likelihood is high that you can't do this. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
??Programmatically set security level to medium
Hi
in addition to Harlan's answer: If you would be able to do this programmatically which would undermine the security purpose of this feature (weak as it is). So no where should be no way to do this (and there is none) -- Regards Frank Kabel Frankfurt, Germany DG wrote: Using Excel 2000, can I programmatically set the macrossecurity setting to medium on open? Hunted high and low (pardon the pun) but can't seem to find anything that specifically says "no", although "yes" hasn't really come up either! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
??Programmatically set security level to medium
"Frank Kabel" wrote...
in addition to Harlan's answer: If you would be able to do this programmatically which would undermine the security purpose of this feature (weak as it is). So no where should be no way to do this (and there is none) Never say never. Actually it can be done with SendKeys, and there's no way to prevent that. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
??Programmatically set security level to medium
In addition to Harlan's answer
-- Regards Frank Kabel Frankfurt, Germany DG wrote: Using Excel 2000, can I programmatically set the macrossecurity setting to medium on open? Hunted high and low (pardon the pun) but can't seem to find anything that specifically says "no", although "yes" hasn't really come up either! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros/Security Level | Excel Discussion (Misc queries) | |||
| Macro security level in excel will not change to medium or low | Setting up and Configuration of Excel | |||
| Read security level | Excel Programming | |||
| Low Security and this runs, Medium it doesn't - Why? | Excel Programming | |||
| Changing security level | Excel Programming | |||
Hybrid Mode
