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
|