Create a copy always checked

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.

I would like users to be able to copy worksheets (with protection intact),
but not move them.

The only way I can think to do this is to somehow have the "Create a copy"
check box on the "Move or Copy..." menu always checked.

Does anyone know how I can do this?

Tim
 
I don't think you can change those builtin dialogs.

You may want to protect the workbook (stopping all moving/copying), but then
provide a macro that does only what you want to support.

Be aware that workbook protection isn't going to stop anyone who really wants to
do this. It's not that robust.
 
Back
Top