How to prevent manual data entry in cell contains formulas

**vivek_vx** · 10-29-2013, 07:59 AM

Hello Friends,

I have an Inventory file with 3 sheets Input, inventory and stock. when I enter data in input sheet it automatically enters in inventory sheet and running total is calculated in stock sheet. I have tried to protect sheet with password but after this input sheet wont enter data in inventory sheet. I want to protect inventory and stock sheet so no one manually modify or delete data in cells containing formulas. also help to hide and protect formulas.

Pls help...

**vorabha** · 10-29-2013, 08:50 AM

Hi, Vivek_vx

you have correctly choosen protected cell as Locked / Unlocked ...., and hidden where ever formula you wish to hide ...
i found no issues, except while opening of the file their was prompt for Micro Enable, ....

just check on them, rest seams fine.

BhaVesH

**sktneer** · 10-29-2013, 09:29 AM

After protecting your sheet, you can use "Yourworksheet".Unprotect Password:="Your Password" in the beginning of the code (you are using to enter the data in the database) just after you set the worksheet variable and "Yourwoeksheet".Protect Password:= "YourPassword" just before the End Sub to enable the entry on the protected sheet.

**vivek_vx** · 10-30-2013, 08:12 AM

hi friends

I want to prevent other users to edit or delete any data from Inventory and stock sheet. But if I protect work sheet with password input sheet gives me errorerror.jpg

Is their any way to disable keyboard input in inventory and stock sheet or any password protected coding in VB