Custom view & macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khalil Handal - 10 Dec 2007 18:09 GMT

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.

Reply to this Message

Dave Peterson - 10 Dec 2007 18:24 GMT

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 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.

Signature

Dave Peterson

Reply to this Message

Khalil Handal - 10 Dec 2007 18:29 GMT

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

> Did you try recording a macro when you did View|Custom View, selected your
> view
[quoted text clipped - 6 lines]
>> 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.

Reply to this Message

Dave Peterson - 10 Dec 2007 18:34 GMT

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.

> Hi,
> I am doing this so as to show subtotals only.
[quoted text clipped - 20 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Khalil Handal - 10 Dec 2007 19:21 GMT

I will.
Thanks for the help

> Personally, I don't use Custom views very often.
>
[quoted text clipped - 30 lines]
>> >
>> > Dave Peterson

Reply to this Message