Stack Overflow
Stack Overflow

Questions tagged [spreadsheet-protection]

Use for questions about programmatically interacting with inbuilt protections in any spreadsheet. Use with appropriate spreadsheet software tag like [excel], [google-sheets], [libreoffice-calc], [openoffice-calc] and the language tag like [python], [google-apps-script]. Do NOT use for non-programmatic usage.

Protection is a inbuilt feature in most spreadsheet software, where some parts of the spreadsheet like sheet or range can be protected from unwanted edits from users.

Feature Reference:

54 questions
0
votes
1 answer

In Excel VBA how can I enable comments on a protected sheet but still protect form controls

I have a protected Excel sheet. It has form controls and I have assigned macros to them. I can enable comments on this sheet by using .Protect DrawingObjects:=False but this also allows any form controls to be deleted. I could change the form…
MrPea
  • 635
  • 1
  • 6
  • 22
0
votes
1 answer

How to?: Excel protect pivot table, but still have expandable functionality

I have an excel powerpivot table and I've protected the sheet and cells. 1) I'm trying to have the pivot table to be functional and multiple users to expand/collapse fields while the whole sheet is protected. 2) Important: Each user will have their…
Dataletx
  • 25
  • 2
  • 9
0
votes
1 answer

Restrain user interaction within a specific cell range in a sheet

I would like to limit the range in which the user can navigate though the cells. To explain better, suppose that range is within the rows 1 to 10 and columns A to G. The user cannot select any cell outside that limit or explore cells outside that…
Bruno Lopes
  • 169
  • 7
  • 20
0
votes
1 answer

Excel - having different permissions for different ranges on one tab

I am trying to have on one a tab a section where users cannot edit or modify the cells in any way (only point and click), and then another section where they can only paste/copy/delete entries with the cells (but not change the formatting). I do…
alexander_N7
  • 3
  • 1
0
votes
1 answer

Protect specific area in excel with vba

I wanna proctect a specific area or only rows in a excel sheet where the user can make changes. the red area should be protected, is this possible and realizeable with vba? And is it possible to make the protec scalable, when the user insert a new…
Synoon
  • 2,297
  • 4
  • 22
  • 37
0
votes
1 answer

Excel thinking cells are locked when they aren't

I have quite a complicated workbook which i have very heavily locked down so it cant lose its structural integrity when being used by the user. It works like a dream in Excel 2003, 2007 and 2010 however when i use it in 2013 if i try and type in to…
Ian Gough
  • 43
  • 1
  • 2
  • 8
0
votes
2 answers

Can VBScript run on protected sheet of an Excel?

I am using VBScript to make lots of calculations on different sheets on the same workbook. Now one concern is if somehow someone deleted any of the sheet, the script would then lead to massive data loss. Is there any way to protect it from users?
CodeLover
  • 1,054
  • 6
  • 24
  • 40
0
votes
1 answer

Macro Edit/View Protection

I have written a VBA macro to do some stuff in Excel, and I want to know if the following is possible. How do I protect a Macro so that no matter who uses the spreadsheet, they cannot edit the code? The protection needs to be strong enough that even…
user154924
  • 43
  • 5
-1
votes
1 answer

google apps script: remove and restore protection

I have a spreadsheet that is editable by everyone with a protected sheet with some ranges unprotected. I want cells that can be altered by a script run by any user (from a menu), but not manually. When I run the script not as the owner it gives an…
Lexcel Atmadata
  • 83
  • 4
1 2 3
4