ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copying visible cells only on a protected worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/92392-copying-visible-cells-only-protected-worksheet.html)

Paula

Copying visible cells only on a protected worksheet
 
I am working on a spreasheet that needs to be protected to block access to
certain cells and at the same time allow users to copy visible only cells in
a specific range (the cells in this range are not protected). The problem I
am having is once the worksheet is protected, edit, go to, special is no
longer available (it is greyed out).

Is there any way to work around this?

Thank you in advance!


All times are GMT +1. The time now is 10:42 AM.

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