Excel vba


This query is : Resolved 

Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
16 November 2011 I want to lock particular cell on some event
and also unlock with other event.

i want to disable addition and deletion of any row and column from the sheet,formating of cells.

16 November 2011 In the 'Review' tab, select option protect sheet. Input a password.

Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
16 November 2011 but i want user to enter values into cells. by doing this user is not allowed to enter values also.

i want to restrict user to edit particular cell if some particular condition is satisfied.

16 November 2011 On the changes tab in Review panel, select allow users to edit ranges. Do not input a password.

Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
16 November 2011 i tries with that also but its not allowing user to provide any input..

17 November 2011 Do not input a password in the 'range password'. leave it blank. then protect the sheet. the user will be able to input data in the range that you specify.


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
13 October 2026
Accountant

Zerdi & Co. Chartered Accountants

Pune

B.Com

View Details
Company
12 October 2026
Chartered Accountant - Internal Audit

HKC | Chartered Accountants & Business Advisors

Ludhiana

CA

View Details
Company
21 October 2026
CA INTER/ BCOM WITH EXPERIENCE

CA S KUMAR GUPTA & CO

Amritsar

CA Inter

View Details
Company
07 October 2026
Senior Account Manager

Amplio Invest

Mumbai

M.Com

View Details
Company
14 October 2026
Asst. Manager/Dy Manager (Costing)

manufacturing

Pune

CMA

View Details
Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
08 October 2026
SALES TELECALLER

HIRE NOVA

Lucknow

Graduate (Any)

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details