Locking Borders. Conditional Formatting

Unfortunately Conditional Formatting doesn't allow you to format heavy borders. :-/ Someone will have to come up with a VBA solution if you still want it.

You should still be able to use VBA. Sounds like you might want two buttons, one to remove all the dark borders (if you insert a row and it creates a dark border you don't want. And one to put in the dark borders? Is that what you want? I will check back tomorrow and write a quick program if no one else does before me.

Okay, I wrote one macro for removing heavy borders (in case you insert lines and the heavy borders are in the wrong places) and one for adding heavy borders between new names. Is this what you want?
To look at the macros, "View Macros"> Edit

Try saving it first, closing it and then reopening it (and enabling macros)

I just redownloaded it and seems there were some external links somehow and it "repaired" them. Then I had to reattach the macros to the buttons. If you are still having problems, try this version attached.

I had similar problems again. Sorry about this. This worked for me. Instead of selecting "Open" when downloading, save it without opening. Then go into excel and open it. Enable macros if you need to. I'll wait.

After you "repair" it, does it still open in "Read only" or do the buttons just not work?

Right click on a button and "Assign Macro" then choose the right macro from the list (either addhvyborder or removehvyborder). Click "OK" Then do the same with the other button. Click elsewhere in the spreadsheet and then try the buttons.

If none of those options work, we can copy and paste the macros directly into one of your working spreadsheets. (it will then need to be saved as an xlsm file). I posted in Programming forum to see if anyone had experience with this error but so far nothing makes sense. Let me know what's up.

Can you record and run macros yourself? It may be that you do not have VBA installed (in which case, you would need your installation disc).

To test this. First Click on the Large Round Office Icon (upper right) and click on Excel Options.
Check "show developer tab in the ribbon" Then Okay.
Now click on the developer tab and "Record Macro" Click okay to the popup window
type your name into a cell and enter. Hit the "Stop Recording" button
Clear that cell, then click on the macros button and run the macro (probably macro1).
If that works, you have VBA.

FYI, there is also a Record Macro button in the bottom left corner of the status bar.

Wow, I always thought it was a little ridiculous to put it on the developer tab only. Thanks RS!

In regards to the issues, I originally thought this might be the problem also (DanD not having VBA) but when I downloaded the file and tried to run it, I had issues too and I'm the one who uploaded it. :/