Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to hide headers
I have a working file with more than 50 sheets. When I send out to my users I
would like to hide both the row and columns headers in every sheets. Can someone help? I am using the below to copy and paste values in every sheet and it worked very well. Not sure if some coding can be added inside the loop. Set WB = ActiveWorkbook For Each SH In WB.Worksheets With SH.UsedRange .Value = .Value End With Next SH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide or Protect Headers | Excel Discussion (Misc queries) | |||
How to Hide Row & Column Headers in Excel ? | Excel Discussion (Misc queries) | |||
Hide Column Headers but not row (Headers) | Excel Programming | |||
Show/Hide Column and Row Headers | Excel Discussion (Misc queries) | |||
Possible to hide column headers??? | Excel Programming |