Results 1 to 2 of 2

Thread: How to protect excel sheet and formulas

  1. #1

    How to protect excel sheet and formulas



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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....
    Attached Files Attached Files

  2. #2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •