Disable VB Editor
 

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

Disable VB Editor
 

Put a password on it, ToolsVBAProject Propertiesprotection in the VBIDE.
Not foolproof, buts should stop the casual tinkerer.

--
HTH

Bob Phillips

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

"Rob" wrote in message
...
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