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?

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?

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?

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