Pivot table on Forms

[vinay_poojary]

Can anyone help me out on this problem.

I have a data which I want to summarise it in Pivot table. The Pivot table i want should be built & displayed on the form using macros. The pivot table should be not on the excel but on the form beside the table so that no user can change that pivot table.

Pla help me on that

[Tom Ogilvy]

what do you mean by the term FORM?

is it a Userform - no support for hosting a pivot Table

do you mean a worksheet dressed up to resemble a Paper Form?

A pivot table can be located almost anywhere on a worksheet where there is
room for it. There are various protection options associated with a
worksheet. You can lock and unlock cells and then protect the sheet. You
can enable pivot table changes as an option as well (xl2002 and later, with
code in xl97 and later).

--
Regards,
Tom Ogilvy


"vinay_poojary" wrote:

>
> Can anyone help me out on this problem.
>
> I have a data which I want to summarise it in Pivot table. The Pivot
> table i want should be built & displayed on the form using macros. The
> pivot table should be not on the excel but on the form beside the table
> so that no user can change that pivot table.
>
> Pla help me on that
>
>
> --
> vinay_poojary
> ------------------------------------------------------------------------
> vinay_poojary's Profile: http://www.excelforum.com/member.php...o&userid=36182
> View this thread: http://www.excelforum.com/showthread...hreadid=560988
>
>