show macro security setting in a cell

[Mark]

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?

 

[Frank Kabel]

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")

 

[Mark]

Thanks very much--works like a charm. Simple and very effective. Thanks again!

 

[baat4]

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?