Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Bryant Smith on Dec 29 In MS Office Category.

Entering Data in Locked Cell

Question Answered By: Alvin Nguyen on Dec 29

I believe you want...

ActiveSheet.Unprotect

Do stuff

ActiveSheet.Protect

If you have a password set, add it to the code...

ActiveSheet.Unprotect "password"

Do stuff

ActiveSheet.Protect "password"

This Question has 2 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Entering Data in Locked Cell Or get search suggestion and latest updates.

Related Topics:

Buttons locked while editing cell data
Moving data in the last cell of row to another column cell
Copying current cell's value to another cell
Can I lock formats, but not cell contents?
Finding and replacing the cell next to a cell with a certain string
Copy Value produced by formula in cell C3 to cell D3
Update a cell based on a DDE updated cell value
active cell no longer advances to cell below
Action taken by Excel when a condition causes a cell's value
Function needed to split the content of a cell intomany cells
Function needed to split the content of a cell into many cells
how are cell coordinates referenced on a clicked cell
to see if text in a cell in a column is contained in any cell
Cell validation based on the contents of previous cell
A Paragraphs in one cells --> convert into a line in per cells
Copy cell contents to same cell on different worksheet if contains
Entering Data Through Button Click
write a program that enters double data into an ArrayList and calculate the total
code for saving the data in another workbook while entering in one
Determine the data type of a cell

Tagged:entering data in locked cell

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us