Disable VB Editor

[Rob]

Is it possible to disable the VB Editor unless the workbook is opened by a
certain user? Reason being is that I don't want just anybody to be able to
change my code unless it's me.

Thanks In Advance,
Rob

 

[Bob Phillips]

Put a password on it, Tools>VBAProject Properties>protection in the VBIDE.
Not foolproof, buts should stop the casual tinkerer.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)