Custom view & macro

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

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.
 
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.)
 
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
 
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.
 
I will.
Thanks for the help



Dave Peterson said:
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.
Click to expand...
 
Back
Top