Macro Security, Password Recovery & VB Code execution

A

Anand

I have found that if I set my macro security to high, VB
code within (non-trusted) excel sheets do not execute...
a microsoft security feature that ostensibly prevents non-
trusted users from running VB

The questions I have are :

Is there a way to guarantee VB macro-execution using
digital certificates or what-have-you ?

Is there a way to detect, either within excel (well,
not possible, it seems) or from outside, that the combo
of users macro-security settings and signature status of
a perticular excel file, WILL prevent VB from executing,
if the file is attempted to opened ?

I have seen password recovery software at work and
extract VB / Sheet passwords ...... can these software
programs work on excel files that are open, or do all
these password recovery softwares require that the excel
file be closed ?

Thanks for any inputs. God bless
 
Top