View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_116_] Mike[_116_] is offline
external usenet poster
 
Posts: 1
Default 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