View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
BigPig BigPig is offline
external usenet poster
 
Posts: 77
Default 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