Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table on Forms
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 -- vinay_poojar ----------------------------------------------------------------------- vinay_poojary's Profile: http://www.excelforum.com/member.php...fo&userid=3618 View this thread: http://www.excelforum.com/showthread.php?threadid=56098 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table on Forms
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |