View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charles Jordan Charles Jordan is offline
external usenet poster
 
Posts: 56
Default Code to create a right click short cut menu

Hi I am trying to manipulate multiple controls on a worksheet plus
some drawing objects and in the days of XL95 John Walkenbach had a
marvellous "Power Utility Pak" "Object Properties" tool for altering
both the location of objects and whether they were Visible/Invisible.

One of its great features was that it was accessible by selecting the
object and then *right clicking* it. We are now trying to reproduce
this right click ability but cannot find any code on this NG for doing
it.

Can any one, (including John) help?. Mr Walkenbach if you are there
perhaps you could direct us to the page in "Power Programming with
VBA" although its not immediately obvious that the code for this
feature is in the book..

(We are running XL 2000, /XP).

Thanks a million

Charles