Excel Security

[Jeff]

Hello,

In need at work, to "implement excel protection to prevent users from
changing formulas and and visual basic code"....i have tried protecting
sheets, and the entire workbook, but one can still get into and edit
macro/visual basic code

Can anyone help?

Thanks
Jeff

 

[Arvi Laanemets]

Hi

In VBA Project window, right-click on VBA project and select
Properties.Secutity from drop-down.

 

[RADO]

Go to your Visual basic, select the name of the project where your code is
stored, right-click on it and select "VBA PRoject properties". The select
VBA protection.

Best -
RADO