Protecting Cells with Macros

[sighlent1]

Hey,

I'm working on this project for our company's Quality Control

I have a few macros in this excel spreadsheet that work GREAT. Now that I have everything working, I want to protect the formulas in some sheets so that when the manufacturers plug in the data they don't accidentally delete anything they're not supposed to

When protecting the cells in the sheets, I get an error message, which I can't figure out what wrong, or if there's an alternative way to protect these cells. I've just been locking the cells then protecting the sheet

In Sheet1, to test to see that the program is functioning properly, push the "Random Number Generator" button, then the "Record Data" button and the data will be recorded in the corresponding Model # in the worksheets

Specifically, I've been trying to protect these cells:
Worksheet: "1098"; Cells: A1:DR24
Worksheet: "1190"; Cells: A1:DR24
Worksheet: "1220"; Cells: A1:DR24


If someone could help me out, I'd really appreciate it

Thank you for your time
Bob

[Paul]

Hi Bob,

If you want macros to work on protected sheets, you usually have to unprotect the sheet at the beginning of your code, then re-protect it when the macro finishes. For example:

Please Login or Register  to view this content.

[sighlent1]

EXCELLENT!!!!.......Thank you sooooo much Paul...this is EXACTLY what I was looking for

Thanks
Bob