Disable Move, but not Copy

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Excel Protection 2
PROTECT MACRO IN NEW WORKBOOK 1
Save with ref. to cell A1 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
save file using information from a cell 1
Sheets won't move 7
path to macros being changed 6

Back
Top