| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Move or Copy functionality
I have disabled the command control on the menu bar for:
File / File Save As and for Edit / Move or Copy Sheet How can I disable the "Move or Copy" functionality you get by right clicking the sheet tab at the bottom of a spreadsheet? Thanks for any suggestions. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Move or Copy functionality
Hi
You can disable the whole menu like this Application.CommandBars("Ply").Enabled = False Or only the Move Copy Application.CommandBars("Ply").FindControl(ID:=848 ).Enabled = False See also http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "TimN" wrote in message ... I have disabled the command control on the menu bar for: File / File Save As and for Edit / Move or Copy Sheet How can I disable the "Move or Copy" functionality you get by right clicking the sheet tab at the bottom of a spreadsheet? Thanks for any suggestions. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i disable/enable "Worksheet Move or copy" option? | Excel Worksheet Functions | |||
| Disable sheet copy/move | Excel Programming | |||
| Prevent / Disable Worksheet Copy or Move | Excel Programming | |||
| Disable 'Add or Remove buttons' functionality on a toolbar | Excel Programming | |||
Hybrid Mode
