Macro to Create Pivot Dynamically

**naveenmarapaka** · 09-09-2012, 08:33 AM

Hi Dears,

I have created a macro to create Simple Pivot table and set in my tool bar so that i can use it for another workbooks as well.

the following Code is working fine in same file where i have created macro basically, but not working with other workbooks.

Pls help me in VBA code , how can i made with work with other workbooks,

Note: Fieldname "AlertedBy" will be same in otherbooks as well but still not working.

Please Login or Register  to view this content.

**alansidman** · 09-09-2012, 08:48 AM

You need to put the Macro in a Personal.xlsb file. Here is a tutorial on how to create that file.

http://www.rondebruin.nl/personal.htm

**Cutter** · 09-09-2012, 09:23 AM

@ naveenmarapaka

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

**naveenmarapaka** · 09-09-2012, 11:02 AM

Hi Alan I did the same as explained,

Format is my Personal File which all modules that to run, and another is for test purpose to see the result.
I have total 2 modules now, in which 1 Module has 6 procudures to call and it is working excellent when running in other workbooks even my Personal file Format.XlS is completely password protected including VBA Code.
Second module is pivot_chart which has the Error it is always saying to unlock the worksheet to run and even after unprotecting the sheet, still it has the problem, code is not working on other workbooks.

I want to attach the Excel Files of my personal and test.xls but unable to do attach.