How can I lock a table between 5th-15th of a month using vb codes? its very urgent guys plz help.
How can I lock a table between 5th-15th of a month using vb codes? its very urgent guys plz help.
write this code:
Please Login or Register to view this content.
i just want to lock the cells contains formulas, and want to enter the data with locked formulas plz help me out as soon as possible
1) select all cells on sheet (Ctrl+A)
2) open "format cell" window (Ctrl+1)
3) select tab "protection"
4) uncheck "locked"
5) Close window (OK)
6) select cells with formulas
7) open "format cell" window (Ctrl+1)
8) select tab "protection"
9) check "locked"
10) Close window (OK)
use my code
No its not protecting,,,,,,i just want to protect formula cells because same file others are also using and by mistake they delete formulas, for example, a1+b1=c1,,,i want others (my employs) to enter data in a1 and b1 and to protect c1 from them .......is it possible..???
Yes it is possible if you will do what I wrote above
22.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks