1004 (Unable to set LineStyle prperty of the Border class)

**TimlmiT** · 10-10-2014, 10:05 AM

Gurus,

I am not sure why this error has popped up. The code worked before I put in call statements to unprotect the worksheet, then protect the worksheet once it was complete. Even so, the range AJ52:AL52 is not even locked. It must be something simple that I am missing.

FYI, I tried the code with and without a (with - end with) statement. It errors out both ways.

The code errors out at .Linestyle = xlNone

Please Login or Register  to view this content.

Here is a copy of my untest (unlock) and lockform code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

TIA,
Tim

**TimlmiT** · 10-10-2014, 10:56 AM

My apologies.

I found the error. I had another call statement to unlock and lock the form in another part of the code when "sample" was changed. Therefore, the form was locked before the .lineStyle code could be executed.

I knew it had to be something I was over looking.

Tim