Does anyone know how to hide a column AND suppress its data… in a macro? Given Columns A, B, and C, I want to be able to not only hide one of the columns, but get all charts and formulas that reference values in Column B to no longer include the data in Column B.
2007-02-28 04:45:31 · 2 answers · asked by sheenabean 1 in Computers & Internet ➔ Software
I think it would be easier to make 2 charts-- one with column B and one without-- and use your macro to hide whichever chart isn't needed at the moment
2007-02-28 05:51:06 · answer #1 · answered by rod 6 · 0⤊ 0⤋
you can do that.. thats very much possible. Again you just have to use rite formulas and rite chart creation techniques.
I would also know your requirement in detail to help you on this.
If you can message me at herochenna@yahoo.com i can help you on this rite away.
2007-02-28 08:08:35 · answer #2 · answered by Anonymous · 0⤊ 0⤋