security using VBA

[bloodmilksky]

Good Morning Guys,

I was just wondering if anyone knew of some code that I could enter into my workbook that would stop modifications from happening to anything other than 2 cells that are used for searching data?

Many thanks

bloodmilksky ^_^

 

[jtakw]

Hi,

If I understand, you don't need code...

From Cell Formatting, make certain all cells containing formulas are marked "Hidden", all cells are marked "Locked" EXCEPT for the 2 cells you want user input. PROTECT the Sheet(s), PROTECT the Workbook, PROTECT your VBA Project.

 

[ww4612]

Good evening,
you can select the entire sheet, right click, format cells, protection, check locked. then select the 2 cells, uncheck the lock. then go to review in the menu click protect sheet under changes group, and click ok.

 

[bloodmilksky]

Hi,

I have tried both methods and both stop the Code From running that I have on the workbook.

Many thanks

jamie

 

[jtakw]

If you have code running on protected sheets, within your code, set:

UserInterfaceOnly:=True

 

[Peter_SSs]

Hi,

I have tried both methods and both stop the Code From running that I have on the workbook.

Many thanks

jamie

Two options:

1. Have your code unprotect the sheet before it does its work and then re-protect the sheet at the end.

2. Protect the sheet "UserInterfaceOnly". See here for example & a little more info.