W
Wike05
Wike05 3/16/2006 5:09 AM PST
Question
Im using pivot tables to make reports for my boss in excel. But she has no
idea how to use them so i recorded macros that set the different reports up
for her. The problem is i need the macro to clear the current layout in the
pivot
table before it applies the new layout.
Was this post helpful to you?
Reply Top
robert111 3/16/2006 5:23 AM PST
Can you write a separate macro to do the clearing, and attach it to a
prominent button object that she can click before resetting.
Alternatively, put each pivot on a separate sheet and then all she needs to
do is open the required sheet. -- robert111
------------------------------------------------------------------------
robert111's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=31996 View this
thread: http://www.excelforum.com/showthread.php?threadid=523058
Was this post helpful to you?
Reply Top
Wike05 3/16/2006 6:48 AM PST
i only know how to record and do some minor editing of macros. but i cant
figure what i need to stick in the begining of the macro to have clear the
layout, then apply the new layout.
:
Click to show or hide original message or reply text.
Question
Im using pivot tables to make reports for my boss in excel. But she has no
idea how to use them so i recorded macros that set the different reports up
for her. The problem is i need the macro to clear the current layout in the
pivot
table before it applies the new layout.
Was this post helpful to you?
Reply Top
robert111 3/16/2006 5:23 AM PST
Can you write a separate macro to do the clearing, and attach it to a
prominent button object that she can click before resetting.
Alternatively, put each pivot on a separate sheet and then all she needs to
do is open the required sheet. -- robert111
------------------------------------------------------------------------
robert111's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=31996 View this
thread: http://www.excelforum.com/showthread.php?threadid=523058
Was this post helpful to you?
Reply Top
Wike05 3/16/2006 6:48 AM PST
i only know how to record and do some minor editing of macros. but i cant
figure what i need to stick in the begining of the macro to have clear the
layout, then apply the new layout.
:
Click to show or hide original message or reply text.