Ask a Question

Protecting cells in Excel but allow these to be modified by VBA script

in Education by
I am using Excel where certain fields are allowed for user input and other cells are to be protected. I have used Tools Protect sheet, however after doing this I am not able to change the values in the VBA script. I need to restrict the sheet to stop user input, at the same time allow the VBA code to change the cell values based on certain computations. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
Try using Worksheet.Protect "Password", UserInterfaceOnly := True If the UserInterfaceOnly parameter is set to true, VBA code can modify protected cells.

Related questions

0 votes
Q: Protecting cells in Excel but allow these to be modified by VBA script
    I am using Excel where certain fields are allowed for user input and other cells are to be protected. ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 17, 2022 in Education by JackTerrance
0 votes
Q: Powerpoint VBA to search for and change colour/highlight keywords in textbox
    I am very new to VB and am exploring this method to simplify mundane manual work process of highlighting ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 7, 2022 in Education by JackTerrance
0 votes
Q: VBA PowerPoint Online Guide and How to Record a Macro
    Could anyone recommend to me a good online guide to PowerPoint VBA? Also, does anyone has advice on how ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 16, 2022 in Education by JackTerrance
0 votes
Q: VBA PowerPoint Online Guide and How to Record a Macro
    Could anyone recommend to me a good online guide to PowerPoint VBA? Also, does anyone has advice on how ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 16, 2022 in Education by JackTerrance
0 votes
Q: How to retrieve data from access database(.accdb) into excel using vba
    I'm working on Excel VBA macros and I want to retrieve data from a MS Access database (.accdb ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 11, 2022 in Education by JackTerrance
0 votes
Q: Excel VBA application.visible immediately set back to True
    I have set up a new, empty, modeless userform, to fix my problem with the least amount of code ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 1, 2022 in Education by JackTerrance
0 votes
Q: VBA Excel : Lookup mutiple values & return matched value to the next cell
    This question is corresponding to this link VBA Excel : Extract data in specific format from CSV files but ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 13, 2022 in Education by JackTerrance
0 votes
Q: What are some of the Excel VBA functions commonly used?
    What are some of the Excel VBA functions commonly used?...
asked Oct 19, 2020 in Technology by JackTerrance
0 votes
Q: How can I write an Excel macro to select a group of cells?
    I'm looking for a macro which can be run to select a consistent range of cells so that I can ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 11, 2022 in Education by JackTerrance
0 votes
Q: which excel function is used to combine conrents from different cells into one cell?1. concatenate()2. consol()3. void()
    which excel function is used to combine conrents from different cells into one cell? 1. concatenate() 2. consol() 3. void() 4.main() Select the correct answer from above options...
asked Dec 14, 2021 in Education by JackTerrance
0 votes
Q: How to combine two Excel files with the same fields but different data (different years)?
    How to combine two Excel files with the same fields but different data (different years)?...
asked Oct 29, 2020 in Technology by JackTerrance
0 votes
Q: how can i create a script in which i can search someone number and it will provide me name, country, email in an excel file format.(php is used in this)
    how can i create a script in which i can search someone number and it will provide me name, country, email in an ... is used in this) Select the correct answer from above options...
asked Dec 23, 2021 in Education by JackTerrance
0 votes
Q: how can i create a script in which i can search someone number and it will provide me name, country, email through truecaller database in an excel file format
    how can i create a script in which i can search someone number and it will provide me name, country, email ... an excel file format Select the correct answer from above options...
asked Dec 23, 2021 in Education by JackTerrance
0 votes
Q: In computer security _______ means that computer system assets can be modified only by authorized parities.
    In computer security _______ means that computer system assets can be modified only by authorized parities. A. integrity B. confidentiality C. authenticity D. availability...
asked Mar 12, 2023 in Technology by JackTerrance
0 votes
Q: Which of these keywords is used to prevent content of a variable from being modified?
    Which of these keywords is used to prevent content of a variable from being modified? (a) final (b ... programming questions and answers pdf, java interview questions for beginners...
asked Oct 26, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...