View Single Post
  #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?