google sheets protection

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
2,053
Office Version
  1. 365
Platform
  1. Windows
does anyone know how to add protection to google sheets that is the same as with excel's sheet level protection? i have a budget planner in excel that is protected. ranges that require user input are unlocked in properties. I have reproduced the workbook in google sheets but can't figure out the protection side of things. as an add on, i would also love to know how you hand over the google sheet to a client so they are then the "owner" of the sheet.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
put into different area. thanks mods
 
Upvote 0
to answer my own question: protection is different in google sheets. Its assigned when a sheet or sheets are shared with others. The developer or owner of the sheet can share the sheet to others using a link and specifying the recipients level of edit access. When you share a Google Sheet file, all invitees must have a Google account (doesn't mean gmail account) to use the sheet properly. Otherwise, they can download the sheet, do what they need to, then send it back to the owner/developer. for more info, search "google sheets sharing" or "google sheets permissions".
 
Upvote 0
Solution

Forum statistics

Threads
1,223,999
Messages
6,175,882
Members
452,679
Latest member
darryl47nopra

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