how do I hide part of a column
Wayne,
You could try recording a macro. AQ23 - AZ23 refers to a specific cell
range, as opposed to columns. So I am assuming that you mean columns AQ:AZ.
Tools, macro, record new macro.
'Do your thing, in your case highlight the columns, right click, hide'
tools, macro, stop recording.
ALT + F11, click on modules, and you should see what you recorded.
Following that you could try: In design mode, insert command button
somewhere in your worksheet, double click the command button, insert/paste
the macro you recorded earlier. Exit design mode.
"Wayne" wrote:
I want to Be able to hide columns AQ23 - AZ23 only can someone help with this.
Thanks Wayne
|