PDA

View Full Version : How to protect excel sheet and formulas



vivek_vx
10-17-2013, 08:04 AM
Hi Friends, I want to lock my excel file so no one can view or edit formulas, VB functions or manually delete or modify worksheet data, I have 3 sheets Input, Inventory and Stock, If I enter data in input it automatically add to inventory sheet and calculate running total in stock sheet. once its done the input sheet gets blank for next data entry, I tried to protect cells containing formula and assign password to sheet but when I enter data in Input sheet it wont write to inventory sheet and also doesn't get blank.Pls Help....

p45cal
10-17-2013, 01:31 PM
for others, cross posted at:
http://www.excelforum.com/excel-programming-vba-macros/961986-how-to-protect-excel-sheet-and-formulas.html
http://www.excelguru.ca/forums/showthread.php?2265-How-to-protect-excel-sheet-and-formulas