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

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