Excel Security

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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
 
Hi

In VBA Project window, right-click on VBA project and select
Properties.Secutity from drop-down.
 
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
 
Back
Top