Copy protected sheet to another book?

C

cybern8

New Member
Joined
Sep 20, 2010
Messages
9
My workbook has a protected worksheet (including mostly locked cells); but I want to allow users to copy the worksheet (either by the worksheet "Move or Copy" function, or by clicking the upper-left corner to select all cells) to paste it into their workbooks (which I want no part of).

Is there a parameter I can set in the SheetX.Protect function to allow this flexibility?

The other options I can think of are:
* unlock all cells to allow selecting and copying the entire worksheet;
* unprotecting the sheet for those specific users only (by VBA);
* giving those users the password;
* just unprotecting the sheet, period.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Sort by date Sort by votes
Take a good look at the protect function in Excel. it probably has what your looking for in there. Usually I go through and unprotect the cell I am confortable with usres typing in and protect the rest.

Then when setting up the protection just scroll through thr set of check-boxes and I more that likely find what your looking for. I usually only have one check-box checked off " second to the top" I believe.
 
Upvote 0
If a worksheet is Protected you should still be able to Move or Copy. If you cannot, then perhaps you have the Workbook Protected instead of or as well as the Worksheet.

When Protecting the Worksheet, provided you allow users to select both locked and unlocked cells they should be able to copy those to another sheet anyway. Are you sure you cannot do that?

What version of Excel are you using?
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Paste results of Filter Function in place, or in separate sheet
Replies
0
Views
113
bertible
B
W
  • Question
Protected sheet disables macro buttons
Replies
5
Views
338
warda11
W
S
  • Question
How can you insert images on a protected worksheet in a protected workbook?
Replies
1
Views
613
spurs
S
M
  • Question
Filtering / Sorting a protected Sheet
Replies
1
Views
689
ExcelToDAX
E
SaraWitch
  • Question
Unprotect/protect all worksheets with a checkbox
Replies
3
Views
595
skillilea
S

Forum statistics

Threads
1,214,991
Messages
6,122,628
Members
449,095
Latest member
bsb1122

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top