Home |
Search |
Today's Posts |
#1
|
|||
|
|||
show macro security setting in a cell
is it possible to show users their macro security setting in a cell? My
workbook has macro in it, so if they don't enable macros or have their security set to high, the macros won't work. What I'd like to do it show the user in a cell what his/her security setting is and based on the cell value (if the macros are disabled), show a warning. Can this be done? |
#2
|
|||
|
|||
Hi
one way: 1. Create a UDF in your workbook like the following public function MacroActive() as boolean MacroActive=True end function 2. In yur worksheet use the following formula =IF(ISERROR(MacroActive());"No macros active","everything is ok") -- Regards Frank Kabel Frankfurt, Germany "Mark" schrieb im Newsbeitrag ... is it possible to show users their macro security setting in a cell? My workbook has macro in it, so if they don't enable macros or have their security set to high, the macros won't work. What I'd like to do it show the user in a cell what his/her security setting is and based on the cell value (if the macros are disabled), show a warning. Can this be done? |
#3
|
|||
|
|||
Thanks very much--works like a charm. Simple and very effective. Thanks again!
"Frank Kabel" wrote: Hi one way: 1. Create a UDF in your workbook like the following public function MacroActive() as boolean MacroActive=True end function 2. In yur worksheet use the following formula =IF(ISERROR(MacroActive());"No macros active","everything is ok") -- Regards Frank Kabel Frankfurt, Germany "Mark" schrieb im Newsbeitrag ... is it possible to show users their macro security setting in a cell? My workbook has macro in it, so if they don't enable macros or have their security set to high, the macros won't work. What I'd like to do it show the user in a cell what his/her security setting is and based on the cell value (if the macros are disabled), show a warning. Can this be done? |
#4
|
|||
|
|||
"Mark" wrote: is it possible to show users their macro security setting in a cell? My workbook has macro in it, so if they don't enable macros or have their security set to high, the macros won't work. What I'd like to do it show the user in a cell what his/her security setting is and based on the cell value (if the macros are disabled), show a warning. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help Pls re macro cell address | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
Setting macro security level to "low" permanently? | Excel Discussion (Misc queries) | |||
Relative Macro Help on Keystrokes | Excel Discussion (Misc queries) | |||
cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions |