I would like to make a right-click menu similar to the pivot table right click menu. The right-click menu will contain the following items:
[Sort Z-A icon] Sort Descending
[Sort A-Z icon] Sort Ascending
[Wizard icon] Wizard ...
When Sort Ascending is called it should call a subroutine called "MySortAscending()", similarly Sort Descending.
When Wizard is selected, it should launch the pivot table wizard, just like with teh normal pivot table right click wizard.
1) I want an excel spreadsheet with a sample pivot table in it.
2) When you send it to me I will open it, then right click on the pivot table. I will expect to see my menu as I specified it.
3) I will then incorporate the code into my project.
4) You do not own the "copyright" to this code. I do.
Windows 2000/Office 2000.
Office XP is fine too.