Invisible hide the formulas from all sheets in workbook based on Green color

[farrukh]

Experts !
Required one script VB that hide all the formulas in all worksheets based on green color . with some protection no one edited the formulas.
The sample sheet attached.

[Bernie Deitrick]

Not sure what you want, but try code like

Please Login or Register  to view this content.

[farrukh]

Bernie Deitrick ,
Sorry not make understand well.
Required that cells which are in green color when any one click to the cells not find any formula to see ...

[Bernie Deitrick]

If you want to do that, lock those cells and unlock any others, and protect the sheets choosing to disallow selection of locked cells, and allow selection of unlocked cells.

[farrukh]

Have 100+ worksheet in a workbook do manually one by one ?

[Bernie Deitrick]

No - use a macro:

Please Login or Register  to view this content.

[farrukh]

Thank you great job

[farrukh]

Sorry when try to run on original file finding range class error.

attached screen shot


Able to find the issue the file containing merged cells also

Replace
c.Locked = False
TO
c.MergeArea.Locked = False