Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mark
 
Posts: n/a
Default 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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Mark
 
Posts: n/a
Default

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   Report Post  
baat4
 
Posts: n/a
Default



"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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help Pls re macro cell address Hugh Jago Excel Discussion (Misc queries) 2 January 5th 05 10:01 PM
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? Markus Obermayer Excel Discussion (Misc queries) 1 January 4th 05 09:01 PM
Setting macro security level to "low" permanently? Arobind Excel Discussion (Misc queries) 1 December 22nd 04 02:41 AM
Relative Macro Help on Keystrokes Neal Zimm Excel Discussion (Misc queries) 9 December 15th 04 01:31 AM
cell reference show cell name (ie. D45) and not cell value ria Excel Worksheet Functions 4 November 6th 04 05:38 AM


All times are GMT +1. The time now is 03:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"