There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:
http://www.contextures.com/xlPivot06.html
Paperback Writer wrote:
I'd like to create a dropdown where the user selects a date. However, I'd
rather not use data validation. Data validation requires that I have a
column somewhere filled with dates. I'd like the dropdown to have those
dates going backward from today's dates - forward dates are not allowed.
Thoughts?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html