ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disable "Move or Copy sheet "action (https://www.excelbanter.com/excel-programming/395459-disable-move-copy-sheet-action.html)

armaSANEA

Disable "Move or Copy sheet "action
 
Hello,



I need to find a way to disable certain Excel functions, like the Move or
Copy sheet action. I would like to ask for some good advice on how to do this.



Also, although I understand this is highly unlikely, but is there any way to
control the parameters shown in the Move or Copy form? (from Edit -- Move or
Copy sheet). Is there ay way to remove the item "(new book)" from the "To
Book" dropdownlist?

If not, perhaps I could disable the dropdownlist altogether? This way moving
or copying could be done only within the current workbook.



Thanks for reading!




All times are GMT +1. The time now is 01:19 PM.

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