How to hide cells that are already locked with VBA

[Yoepy]

I've created a spreadsheet which has a lot of protected cells, spread all of the sheets. Now that it's finished, I want the cells hidden also (yes I know it would have been easy to do it as I went).

Can one of you brainy people please give me a piece of VBA code, that will find, lock and hide all cells that are already formatted as locked.

Thanks in advance
Yoepy

 

[My Aswer Is This]

Individual cells cannot be hidden.
You must hide the entire row or column

 

[Yoepy]

I must not have been clear enough.

I mean Format Cells, Locked and Hidden.

They are all just currently Locked.

 

[My Aswer Is This]

I must not have been clear enough.

I mean Format Cells, Locked and Hidden.

They are all just currently Locked.

I understand what you want.

You want to lock Range("A1") and Hide Range("A1") for example.

You can Lock Range("A1") but you cannot Hide Range("A1")

You can hide the formula in the cell but not the cell

 

[Yoepy]

No, I don't want to hide Range("A1") I want to hide the formula in the cell as per the second part of your post. I just don't want to go through and find every one and do it manually, there are hundreds.

So what would normally be done Right Click, Format cells, Protection, and tick Locked and Hidden.

 

[My Aswer Is This]

In your original post you said:

I want the cells hidden also​

.


This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[jtakw]

Hi,

The simplest way is to Click the upper left corner of the Sheet (there should be a triangular symbol) between Column A and Row 1, right click, Format cells, check the box "Hidden", you're all done.

This will make All cells in the sheet "Hidden" (formulas won't show), even the cells without formulas, but since there're no formulas in those cells, there's nothing to "hide" anyway.

 

[Yoepy]

Thanks jtakw. Of course, I don't know why I was trying to complicate it.

 

[jtakw]

You're welcome, over thinking a problem happens quite often.