Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Shapes and Events and Custom Menue

Hallo!

Have some shapes on a sheet. And want to do the following:

- get an event if a shape moves/copy/cut/paste
- disable resizing shapes
- disable the Excel right-click menue and replace it by a custom menu

Is this possible?

Thanks in advance

Tom



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Shapes and Events and Custom Menue

Lock your shapes and protect your worksheet.

Yes, you can customize the right click menu (if you mean for cells).

Commandbars("Cell")

--
Regards,
Tom Ogilvy

"Tom G." wrote in message
...
Hallo!

Have some shapes on a sheet. And want to do the following:

- get an event if a shape moves/copy/cut/paste
- disable resizing shapes
- disable the Excel right-click menue and replace it by a custom menu

Is this possible?

Thanks in advance

Tom





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Once again: Shapes and Events and Custom Menue

I think, my questions are not very clear.

I want allow only moving shapes and capture the double click on it, all
other things should be disabled, so editing, resizing, (un)grouping shapes
and so on.

And I want to customize the right-click menu for shapes, for cells, I had
already some success.

And furthermore, is there a possiblity getting events for moving shapes?


Thanks,

Tom


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom shapes Don Excel Discussion (Misc queries) 1 February 2nd 09 05:19 AM
Naming Auto Shapes and Creating new Shapes AL2000 Excel Discussion (Misc queries) 3 September 10th 07 04:12 AM
OnAction events intermittently failing on Shapes in Dialogsheets BizMark Excel Discussion (Misc queries) 0 August 12th 05 01:24 PM
Events on shapes Christof De Backere Excel Programming 1 September 2nd 03 03:35 PM
trapping click events on shapes Matt I Excel Programming 3 August 15th 03 08:17 PM


All times are GMT +1. The time now is 07:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"