hidden cells?

  • Thread starter Thread starter matrix5166
  • Start date Start date
M

matrix5166

To All,
Is there a way to toggle the hidden fields in a work sheet?
matrix5166
 
Depends on how they were hidden...

You can unhide a column. You can unhide a row. You can change the from from
";;;" to General. You can change the font/fill color to something that's
visible. You may have to play with format|conditional formatting.

If you mean hidden fields like MSWord has, then excel doesn't support showing
tabs, paragraph, space characters this way.
 
does this work?

Sub togglehiddencolumns()
Range("a1,d1,f1").EntireColumn.Hidden = Not _
Range("a1,d1,f1").EntireColumn.Hidden
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand and collapse rows 7
Copy Only Visible Cell 1
Multiple sheets should change.. 6
auto filter for number 2
Hidden text in tables causes empty rows 0
Why no "insert copied cells"? 1
Preventing Column Cell Values from Printing 10
Click on website button with tag "button" 0

Back
Top