Remove/Hide Active Cell Border

I have read loads of posts, regarding removing/hiding the active cell border from the selected cell on a worksheet, however, none of the posts I've found actually provide a definitive answer as to whether this is:

a) possible or
b) the correct code to achieve this

Does anyone know if this is actually possible to do and if so, the code that will achieve it?

If it is possible, is there any way to have the behaviour in some sort of toggle format, so it can be either shown or hidden if required?

Many thanks...

Hi Tom,

I tried this, but it errors on .LineStyle = xlNone?

Any thoughts?

@Tom, Yes, I tried putting the code in a module, but it makes no difference...

@Joseph, yes, exactly that, the thick black border that excel puts round the current selection, not ordinary cell borders.

Um, I agree, this isn't the norm or a common request, but this is for a 'front end' to a series of 'back end' spreadsheets, where it isn't practical to 'protect' the worksheet, but the user really only has the option to select from two drop down data validation lists. Because of the impracticalities of protecting the worksheet, it just looks really messy if the user clicks in any other cells, hence the 'want' to remove the active cell borders from the selected cells...

Hi Tom,

Many thanks for your sample, though I think maybe I didn't explain the problem so well. It is actually the Thick Black Border and Fill Handle when a cell is clicked on that I want to remove, rather than a drawn border on a cell, though your sample could prove very useful for other things, so many thanks for that...

since this doesn't appear to be an option...I'd just create a work around...remove the gridlines, and header, place a white shape with no borders and hide the activecell behind the object. This way the user does not see the location of the selected cell...they will, however, be able to see the address of the selected location...again, its a work around.