HI,
I already posted a thread about protecting the sheets simultanoeusly.
The next case for me is to protect only the cells on all sheets which contain any type of fomrula, starting from just equality "=A1" and aended with combination of any formula.
In other words I need to lock only cells with formulas and than protect them with password. I there any possibility of this? If it will be non-VBA solution that would be great, but if not VBA code also will be great....
Thank you all in advance.
HI G.Bregvadze,
NonVBA solution:-
Press F5 -> Special -> formulas -> OK
now protect (Lock) them and then protect the sheet.
done
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
That is a good solution, but can it be done on all sheets simultaneously? becuase I have lots of sheets..
Yes.. you can select all sheets using your mouse while pressing ctrl key on keyboard and then you can follow above steps except for sheet protection because sheet protection would be applied individually on each sheet.
Regards,
DILIPandey
<click on below * if this helps>
That's it.. thanks for support... great...
You are welcome..
Cheers
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks