Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a copy always checked
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a copy always checked
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. Tim Mc wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Create a copy" always checked | Excel Discussion (Misc queries) | |||
sum if box is checked | Excel Worksheet Functions | |||
sum if box is checked | Excel Worksheet Functions | |||
create macro to copy | Excel Discussion (Misc queries) | |||
Can I insert a box on excel that can be checked and un-checked? | Excel Discussion (Misc queries) |