Enable Macros & Disable Insert from code

[Giri]

Hi,

1. How to enable macros from the code?
2. How to disable insert and copy for this workbook?

Any help is appreciated. Thanks.

Regards,
Giri

 

[Bob Phillips]

1. You don't, otherwise what would be the point.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Giri

For security reasons you cannot programmatically enable or disable macros

Stopping insert and copy may be difficult. Insert can be done via protection, but not sure about how you would handle the stopping of copying. (Pasting could be handled via protection too)