ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Shapes and Events and Custom Menue (https://www.excelbanter.com/excel-programming/320995-shapes-events-custom-menue.html)

Tom G.[_2_]

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




Tom Ogilvy

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






Tom G.[_2_]

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




All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com