Barry Privette
Original Poster
Oct 23, 2019

How can I duplicate a sheet and keep the same protected ranges as the sheet that I copied from?

How can I duplicate a sheet and keep the same protected ranges as the sheet that I copied from? I have seen others ask but there has been no correction of this that I have seen. HELP.

-Barry
Details
Sheets,Mac OS,Business
Locked
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies (5)
Spencer Farris
Platinum Product Expert
Sheets and Apps Script
Oct 23, 2019
Hi Barry,
 
If you copy a sheet of yours, the protections will persist. Please explain more your issue.
Barry Privette
Original Poster
Oct 23, 2019
That is incorrect. When I duplicate a sheet, the protections do NOT. follow. Therefore any protections that I have on any cells, columns, or rows do NOT duplicate with the sheets that I duplicate. Please help.
Spencer Farris
Platinum Product Expert
Sheets and Apps Script
Oct 24, 2019
I literally tested it before posting. Created a sheet, protected a column, made a copy of the sheet (with File > Create a Copy) and the protections were on the new sheet.
Barry Privette
Original Poster
Oct 24, 2019
I am not trying to duplicate the entire file. Going into File > Make a Copy makes a copy of the entire file under another name. I want to copy 1 sheet within that file. So when I right click on a specific sheet that is located on the bottom of the screen, it gives me an option to “duplicate.” In duplicating this  1 sheet, it does not copy protected ranges.
Spencer Farris
Platinum Product Expert
Sheets and Apps Script
Oct 24, 2019
Ah. Follow this guide
false
9402642767193888042
true
Search Help Center
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false
false