Custom view & macro

[Khalil Handal]

Hi to all,
I have a "custom view" named "main_cat" that hides some rows and colomns.
how can have this done using a macro to show this view of the sheet.

 

[Dave Peterson]

Did you try recording a macro when you did View|Custom View, selected your view
and chose Show?

(Those are the menu options in xl2003--not sure where it's hidden in xl2007.)

 

[Khalil Handal]

Hi,
I am doing this so as to show subtotals only.
No didn't , I thought it works "differently".
I am working on Excel 2007 also.
I will try recording the macro.

I am doing this so as to show subtotals only in a report sheet.

Thanks

 

[Dave Peterson]

Personally, I don't use Custom views very often.

I'll just create/record a macro that would do what I want--hide/show columns or
hide/show rows.

You may want to try that instead of custom views.

 

[Khalil Handal]

I will.
Thanks for the help

Personally, I don't use Custom views very often.

I'll just create/record a macro that would do what I want--hide/show
columns or
hide/show rows.

You may want to try that instead of custom views.