How to permit VBA codes to work when cells are protected?

Hello all,

I was just wondering if it's possible to permit the Excel VBA codes that I have to work even when I protect certain cells in my workbook?

As we speak, all my VBA codes work great but when I protect the sheet I receive an error when formula's are attempting to work... Any way of getting rid of this error and let the VBA code do its function when the multiple cells are protected within the workbook?

Thanks in advance,

Pat.

Please Login or Register  to view this content.

also a good way to get simple functions like this is to use the record macro feature. start record, protect the sheet, unprotect the sheet, then stop record and you have your macros. take care!

The code you gave me,

Does it unprotect all my cells that I have protected though? Like I still want those cells to be protected but to be able to permit my VBA codes to work..

Thanks,

Pat.

put the unprotect code at the top of your macro and the protect at the end. they way you had it set up before is the way it will put it back, it does not affect individual cells. only cells flagged as locked.