Excel Security
 

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

Excel Security
 

Hi

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


--
(When sending e-mail, use address )
Arvi Laanemets


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

Excel Security
 

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


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