I've made an Excel file that has 10 sheets to fill in data, and about 30 sheets that hold the actual forms to print.
Sheets 1-10 should be partially open for input and partially locked (of course I made locked and unlocked cells accordingly), sheets 11-30 should be locked and hidden since forms should not be edited by the user.
Untill now, every sheet in my workbook is protected by a password. At least two problems :
1. it's kind of tedious to unlock / edit / lock - and at the end make sure every sheet is actually locked
2. most important : someone claims to have found a little code (PC) to detect my password, well in fact it works.
Is there another way to protect my Excel workbook, with only a limited number of cells open for input ?
TIA
Top
