Hello friends.
I made a workbook and trying to protect. I was able to find some VBA code similar to what I need, but I fail to put them together (lack of experience).
So what I need.
1. I want to protect existing VBA Code in all worksheets.
2. I want to protect all formulas (to hide) in all existing worksheets.
3. If in any worksheet in cell A1 appears something then, automatically remove all sheets except the first sheet, and automatically save the entire workbook.
4. I want to deny users to change certain cells in certain sheets, but I think it is a little complicated because I have filtered columns, some hidden, and VBA code active in the sheets.
However, if it is possible to put together the first three points, I think it is enough.
It is possible to be done in a single step?
Any help is welcome.
Thanks in advance
PS: My English is still very poor...
Bookmarks