Pivot table on Forms

V

vinay_poojary

Can anyone help me out on this problem.

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

Pla help me on tha
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Pivot table multiple filters 2
Pivot table code question 2
Playing back a Pivot Table macros 2
Macro to display Tabular View of Active Pivot Table 1
Link Drop Down list with Pivot Table 3
create a pivot table and chart from a named range 1
Link Drop Down list with PIVOT Table in Excel 2003 0

Top