LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
appeng
 
Posts: n/a
Default Auto Hide Columns & Rows

How can I hide 1 or more columns based on a cells value
For example,
If there is an X in cell A1, column F will be hidden.
If there is an X in cell A2, column F will be visible.

If there is an X in cell A3, column G will be hidden.
If there is an X in cell A4, column G will be visible.

This could be triggered by a macro.

I am using Autofilter for rows

I am using Excel 97.

Art
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide / Unhide columns and rows PaulM Excel Discussion (Misc queries) 8 September 6th 07 12:14 AM
Auto Hide Columns Phil Osman Excel Discussion (Misc queries) 6 September 13th 06 07:32 PM
auto filling columns from rows Ken Excel Discussion (Misc queries) 2 February 23rd 05 09:49 AM
Auto update entire columns / rows??? Kcurtis Excel Worksheet Functions 3 February 3rd 05 10:45 PM
AUTO HIDE ROWS Alan Excel Worksheet Functions 1 November 27th 04 09:13 AM


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"