Macro code that runs despite specific cells being locked.

I have a workbook with six sheets. It has pop up userforms macro infused autofills, clears and automtic saves.

Is there a macro code that will lock specific cells while allowing other specific cells to remain unlocked. Where by my code will still run?

Unlocked Cells are Sheet 1 (D8:J8,D9:J9,D12:D29,F12,G12,F15,G15,F18,G18,F21,G21,F24,G24,F27,G27,F30,F31) AND Sheet 6 (C8:F8,C9:F9,B13:F13,B14:F14,B15:F15,B16:F16,B17:F17,B18:F18,C33:D33,

Is their a way to do this without a password?

Thank you for your help.

Sure. In your code Unpassword protect the sheet. Have the code run. The re password protect your sheet. Just good search VBA password protect sheet

I want a permanent lock on specific cells. As well as specific cells remaining unlocked. Where by my code will still run.

Still the same answer. Lock the cells you want locked. Unlock the ones you don't. Password protect the sheets. That translates into a permanent lock. You said "Where by my code will still run"; your code will still run just fine if you unpassword protect the sheets in code as i described above.

Is this the kind of code that you are thinking I should be using

That is correct

If the password to all your sheets is the same you can loop through all the worksheets, which would avoid any name issues:

Please Login or Register  to view this content.

Thanks for your reply.
ok so I have tried this before.
The problem is that for some reason the new error wont allow the clearcontents to clear in merged cells. where it did not before.
Then I unmerged all affected cells. Then it was a different error. Then soon I was getting problems all over my work book.

I am going to post my entire workbook.

hope fully someone sees something I am not.

Thank you.

There is a lot going on in your workbook. A LOT. Can you be very specific on all aspects of your issue (i.e. Which macro you are trying to run. Which worksheet are we dealing with. What cells need to be locked/unlocked. Are any of the userforms involved. Etc). At this point it is a needle in a haystack.

Thank you for your continued help.

So The way My book works:

Sheet 1 Is My invoice input area

It has two User forms that pop up. one for customers command button "customer profile" activates it (data come from sheet 3)......the second for salesman command button "salesman profile" activates it(data comes from sheet 5)..... They both populate a series of cells on sheet1.

The command button "next invoice number" checks to see if "specific cells" are filled. If they are not, then they are highlighted yellow and the macros is stopped until they are filled.
If they are filled then an "register" on sheet 4 is filled with data.
Then a pdf of sheet 2 is created and sent to a specific folder.
as well, a xls copy of sheet 2 is also stored in a specified folder.
lastly specific cells are cleared and the invoice number is increased by one.

At the begining of this module is a macro that determines the order of all of these items and executes them.

Sheet 2 is a finished copy of sheet1 and is essentially there for the user to easily see there work. As sheet 1 has formulas that are based on different types of work etc..

sheet 6 essentially does the same as sheet 1 except it is for estimates rather than invoices and does not need a finished copy

So all of these user forms, command buttons, modules and code work perfectly while un protected. when i protect sheets (1), (2) (4) and (6). i recieved run time errors.

I tried running the various suggestions of code in there proper places. All of them However, cause errors.

for example The code that unprotects the entire workbook, then runs the code then protects afterwards, gets an error in the "highlight unfilled cells" code. The code says cant do this to a merged cell. so unmerged all the cells and i ended up with the same error.Test with protection code.xlsm

Good explanation. With that being said, this worked just fine for your highlight macro (I commented out the other codes for obvious reasons)

Please Login or Register  to view this content.

I am going to say this as straightforward as I can, not with malicious intent. I think all the issues you are experiencing are simple coding error. You need to make sure you pay attention to every little detail, which can be very challenging sometimes when you have as much stuff going on as what you have.

sheet 1 all 3 command buttons

You misnamed a sheet. "1 Invoice Print" does not exist.

Please Login or Register  to view this content.

sheet 6 next estimate command button.

I suspect it is incorrectly pointing to an ineligible directory. Only you can solve this since it is your directory.