TechQA.

Question

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

score 2273 · Answer 1 · 2016-12-14T09:13:57.447000

0

Answer

2273

Views

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

2.2k views Asked by MrPea At 14 December 2016 at 09:13

score 30018 · Answer 2 · 2013-12-03T11:14:37.517000

Protect Excel Worksheet For Read Only But Enable External Data Refresh

30k views Asked by Dominic At 03 December 2013 at 11:14

score 157 · Answer 3 · 2023-10-21T14:29:05.220000

protect and unprotect a checkbox with a warning give me a erroneous behaviour

157 views Asked by GSerraG At 21 October 2023 at 14:29

score 145 · Answer 4 · 2023-10-23T09:24:30.633000

Google Sheet - Sheet Duplication

145 views Asked by dek At 23 October 2023 at 09:24

score 97 · Answer 5 · 2023-10-27T06:11:31.380000

setUnprotectedRanges fails in Google App Script with The parameters (number[]) don't match the method signature. Why?

97 views Asked by Meaulnes At 27 October 2023 at 06:11

score 96 · Answer 6 · 2023-10-28T12:30:54.203000

Protection.setUnprotectedRanges complain about parameters not matching signature despite passing it the correct parameter

96 views Asked by Meaulnes At 28 October 2023 at 12:30

score 4965 · Answer 7 · 2011-10-13T04:50:52.660000

Sorting Protected Cells Using PHPExcel

4.9k views Asked by Warren Sergent At 13 October 2011 at 04:50

score 140 · Answer 8 · 2021-04-28T14:20:25.957000

Replace user in a protected range by script (Google Sheet)

140 views Asked by Andrea Miassot At 28 April 2021 at 14:20

score 509 · Answer 9 · 2021-05-14T20:29:01.990000

How to ignore already protected sheets with script?

509 views Asked by Ádám Hegedüs At 14 May 2021 at 20:29

score 536 · Answer 10 · 2016-02-13T00:00:42.093000

Workbook.Protect bug with toggling protection

536 views Asked by KingKong At 13 February 2016 at 00:00

score 1950 · Answer 11 · 2022-04-05T06:51:56.567000

Apps Script for Google sheet protection and giving permission to edit for multiple users

1.9k views Asked by LM Ong At 05 April 2022 at 06:51

score 129 · Answer 12 · 2022-06-10T17:16:02.020000

How can I lock editing permissions in Google Sheets using Google Scripts, based on cell color AND continent?

129 views Asked by user1742542 At 10 June 2022 at 17:16

score 2397 · Answer 13 · 2011-11-24T08:00:00.367000

Worksheet protection set using ws.protect - but doesnt unprotect using the Menu (Review - Unprotect sheet)

2.3k views Asked by ashleych At 24 November 2011 at 08:00

score 7232 · Answer 14 · 2014-07-28T16:06:23.167000

userinterfaceonly:=true doesn't seem to allow VBA changes to conditional formatting?

7.2k views Asked by Harley B At 28 July 2014 at 16:06

score 90 · Answer 15 · 2019-12-11T14:47:33.280000

159/5000 How to protect a sheet in excel if the data from another sheet is copied automatically?

90 views Asked by Kristina Kelek At 11 December 2019 at 14:47

score 143 · Answer 16 · 2021-09-21T10:27:07.513000

How to remain the same permission of protected ranges in a new duplicated google sheet created by using google apps script?

143 views Asked by weizer At 21 September 2021 at 10:27

score 351 · Answer 17 · 2021-08-15T20:48:26.120000

Prevent opening file if macros not enabled

351 views Asked by Moayyad Alkeddeh At 15 August 2021 at 20:48

score 295 · Answer 18 · 2021-02-25T13:02:50.577000

How can I get this to protect a sheet on scripting basis (Google Apps Script)?

295 views Asked by onit At 25 February 2021 at 13:02

score 3118 · Answer 19 · 2014-08-16T00:11:22.060000

How to protect from editing only rows that are odd numbered?

3.1k views Asked by SSpoke At 16 August 2014 at 00:11

score 1044 · Answer 20 · 2016-05-01T23:57:01.100000

How to search for and delete named protected range in Google Sheets?

1k views Asked by David Centeno At 01 May 2016 at 23:57

TechQA.

List Question

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

Protect Excel Worksheet For Read Only But Enable External Data Refresh

protect and unprotect a checkbox with a warning give me a erroneous behaviour

Google Sheet - Sheet Duplication

setUnprotectedRanges fails in Google App Script with The parameters (number[]) don't match the method signature. Why?

Protection.setUnprotectedRanges complain about parameters not matching signature despite passing it the correct parameter

Sorting Protected Cells Using PHPExcel

Replace user in a protected range by script (Google Sheet)

How to ignore already protected sheets with script?

Workbook.Protect bug with toggling protection

Apps Script for Google sheet protection and giving permission to edit for multiple users

How can I lock editing permissions in Google Sheets using Google Scripts, based on cell color AND continent?

Worksheet protection set using ws.protect - but doesnt unprotect using the Menu (Review - Unprotect sheet)

userinterfaceonly:=true doesn't seem to allow VBA changes to conditional formatting?

159/5000 How to protect a sheet in excel if the data from another sheet is copied automatically?

How to remain the same permission of protected ranges in a new duplicated google sheet created by using google apps script?

Prevent opening file if macros not enabled

How can I get this to protect a sheet on scripting basis (Google Apps Script)?

How to protect from editing only rows that are odd numbered?

How to search for and delete named protected range in Google Sheets?

Popular Questions

Popular Tags

Trending Questions