Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vb code to hide columns
I have a spreadsheet that multiple people view. I need a macro to hide the
columns that some don't need to see and another macro to unhide the columns. the macro I created hides columns B-M and I need it to hide F-K. The VB code currently is Columns("F:K").Select Selection.EntireColumn.Hidden = True End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vb code to hide columns
Columns("F:K").Hidden = false
and Columns("F:K").Hidden = True and try this which will hide if visible and unhide if hidden Columns("F:K").Hidden = not Columns("F:K").Hidden If this post helps click Yes --------------- Jacob Skaria "pm tlb" wrote: I have a spreadsheet that multiple people view. I need a macro to hide the columns that some don't need to see and another macro to unhide the columns. the macro I created hides columns B-M and I need it to hide F-K. The VB code currently is Columns("F:K").Select Selection.EntireColumn.Hidden = True End Sub |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vb code to hide columns
Surely, you can figure out how to make the change. Or, is there more to your
question? -- Don Guillett Microsoft MVP Excel SalesAid Software "pm tlb" <pm wrote in message ... I have a spreadsheet that multiple people view. I need a macro to hide the columns that some don't need to see and another macro to unhide the columns. the macro I created hides columns B-M and I need it to hide F-K. The VB code currently is Columns("F:K").Select Selection.EntireColumn.Hidden = True End Sub |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
vb code to hide columns
Got it, worked like a charm,Thank you!
"Don Guillett" wrote: Surely, you can figure out how to make the change. Or, is there more to your question? -- Don Guillett Microsoft MVP Excel SalesAid Software "pm tlb" <pm wrote in message ... I have a spreadsheet that multiple people view. I need a macro to hide the columns that some don't need to see and another macro to unhide the columns. the macro I created hides columns B-M and I need it to hide F-K. The VB code currently is Columns("F:K").Select Selection.EntireColumn.Hidden = True End Sub |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
vb code to hide columns
Cheers..
If this post helps click Yes --------------- Jacob Skaria "pm tlb" wrote: Got it, worked like a charm,Thank you! "Don Guillett" wrote: Surely, you can figure out how to make the change. Or, is there more to your question? -- Don Guillett Microsoft MVP Excel SalesAid Software "pm tlb" <pm wrote in message ... I have a spreadsheet that multiple people view. I need a macro to hide the columns that some don't need to see and another macro to unhide the columns. the macro I created hides columns B-M and I need it to hide F-K. The VB code currently is Columns("F:K").Select Selection.EntireColumn.Hidden = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
Hide Code | Excel Discussion (Misc queries) | |||
Hide columns code | Excel Discussion (Misc queries) | |||
hide code does not hide | Excel Discussion (Misc queries) | |||
Hide VBA code help | Excel Worksheet Functions |