View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Walker Tom Walker is offline
external usenet poster
 
Posts: 5
Default Opening an Excel Pivot table sheet with right information

Hi all,

I use EXCEL XP to view my Cube which shows project
information like this.

Project A $100
Project B $200
Project C $300

Now I have a requirement that when the user opens up the
excel sheet it should open his/her project by default. So
if Project B is managed by that user the list should
suppress all other projects (the user can do this, but I
want this to be done by Excel)

The list should only show
Project B $200

I think I will have to do some kind of macro programming
to accomplish this. Is that the right way to do this ?

Thanks,
Tom