Hi...
Can u please let me know how can i protect/unprotect formula cells for entire wokrbook in one command or formula instead of one by one sheet.
Thanks
Hi...
Can u please let me know how can i protect/unprotect formula cells for entire wokrbook in one command or formula instead of one by one sheet.
Thanks
Hi Shafiqe,
first unlock all the cells of the worksheet and the press below keys:-
F5
alt + s
f
Enter
now all formula cell should be selected automatically, now format cells -> lock them
protect sheet. .. done
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Thank you for the solution DILIPandey.
This solution is to protect sheets one by one, but i want to protect cells formula for entire workbook or all sheets at once. kindly suggest.
Regards
Shafique
Okay.. then only solution is Macros (vba).. are you ok with that ?
Regards,
DILIPandey
<click on below * if this helps>
okay......
Hi Shafiqe,
use below code to protect all formula cells of entire workbook :-
Please Login or Register to view this content.
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks