Disable or lock page field

Shailesh

Guest

Posts: n/a

5th Aug 2008

I have three page fields in my Pivot.
First Page Field - Countries has distinct values US , UK , JPN
etc)
Second page field - Employee Type has distinct values Permanent,
Temporary and Contractors
and third Field called Bonus has values Yes and No. I want to diable
the pagefield , called Bonus once I select country not equal to US.
How can I do it using VBA in Excel 2003
Any help on this?

« Allow Edit Objects in protected sheets | Page orientation - Upsidedown? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 Pivot Tables - Page Field Row Height; Disable Select MultItems	delecto	Microsoft Excel Misc	0	31st Oct 2008 09:28 PM
Lock Page Field in a Pivot Table	Timothy via OfficeKB.com	Microsoft Excel Programming	3	13th Mar 2007 02:50 PM
Disable Password Prompt/Disable User Lock	=?Utf-8?B?SnVsY28=?=	Windows XP General	2	25th Aug 2006 02:05 AM
Can I limit and lock a word field (ab text field) ?	=?Utf-8?B?SVQgVHJhaW5lcg==?=	Microsoft Word Document Management	1	30th Jan 2006 03:08 PM
disable mulitple select on pivot page field	belinda	Microsoft Excel Programming	0	12th Jul 2004 02:22 PM