Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Move, but not Copy
I have a workbook with several sheets that macros depend on (ie. reference
by name) I've protected all of the sheets, but the "Move or Copy..." action is still available. I have found that even when protected a user can move the sheet into a new workbook, therefore causing errors in my workbook when the macros run. I have need to copy sheets to new workbook from time to time so I can't just disable the "Move or Copy..." command. Is there anyway to disable ONLY the Move (to another workbook) command? Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Move, but not Copy
Hi Mike -
I believe the Move or Copy command is either "all enabled" or "all disabled"; I've yet to discover a way to disable 'Move' with out disabling 'Copy.' One alternative that's very easy to implement is to protect the workbook. Workbook protection disables the Move/Copy menu item. When you want to copy a sheet, temporarily remove workbook protection. -- Jay "Mike" wrote: I have a workbook with several sheets that macros depend on (ie. reference by name) I've protected all of the sheets, but the "Move or Copy..." action is still available. I have found that even when protected a user can move the sheet into a new workbook, therefore causing errors in my workbook when the macros run. I have need to copy sheets to new workbook from time to time so I can't just disable the "Move or Copy..." command. Is there anyway to disable ONLY the Move (to another workbook) command? Mike |
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 Move or Copy functionality | Excel Programming | |||
Disable sheet copy/move | Excel Programming | |||
Prevent / Disable Worksheet Copy or Move | Excel Programming | |||
Disable Add/Delete/Move Worksheets | Excel Programming |