unlocked cells

Hello, I need to create a button that allows a manager to lock all data input, but will then allow other users to add to the sheet below what has already been locked. I know how to set up the button and password, but everything I do to protect the sheet ends up protecting everything --...

Yesterday, both igold & Akuini were very generous in assisting me with figuring out how to code something. We were able to figure it out (thank you again!!). Here is the thread: Push Down Rows However, now I am up against a different issue, but involving the same piece of code. The code...

We are currently using Excel 2007, The spreadsheet has a lot of different calculators involved and would like to protect the sheet and have only certain cells accessible. I created a form control drop down box that lists about 30 different vendors, the users would click on the drop down to...

I had an application in 2010 which was working fine. I recently have to migrate my application to 2013. There was lot of flickering occurred in 2013. So I have used application.screenupdating = false in beginning of my macro and set it back to TRUE during end of my macro. Though setting of...