ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Create a copy" always checked (https://www.excelbanter.com/excel-discussion-misc-queries/144781-create-copy-always-checked.html)

Tim Mc

"Create a copy" always checked
 
Hi.

I want users of a workbook to be able to copy it's worksheets (with their
protection in tact) but not move them.

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

Does anyone know a way to have this check box default to checked as opposed
to unchecked?

Tim


All times are GMT +1. The time now is 08:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com