can you remove the standard black cell border when clicking on cell?

when you click on a cell , excel automatically puts a black border around it to show which cell your clicking on.

can you remove that? so it doesn't do that.. so that when I double click on a cell to open a file (via previous written code) it wont display the black box where im clicking??

Far as I know you can't, perhaps look at using a button rather than double clicking a cell to open the file?

When you open a new workbook Sheet1 A1 is always activated. You could activate A1 as the first piece of code you run & disguise it that way

i don't think I have explained what I mean properly.

when you click on any cell. Microsoft automatically puts the black border around it which includes the little dot on the right hand bottom corner to drag etc.. can you stop that border from showing??

It depends on the purpose !

For example, see EnableSelection worksheet property …

sorry I don't understand what you mean and the purpose is... I literally just don't want to see it when I click lol ..aesthetic purpose

Hi, I don't think you can turn it off, like I said in post #2 - depending on what you are doing there might be a workaround, for example, .enableselection will prevent you from selecting the cells altogether.

I would suggest just keeping the border, any solution will be more hassle than it's worth for an aesthetic purpose.

Originally Posted by Muzza86

so that when I double click on a cell to open a file
(via previous written code) it wont display the black box where im clicking??

If your code uses an event, you can place the active cell elsewhere as Philb1 wrote …

appreciate the replies. but you seem way above my level. I don't know how to code that

If the worksheet has an object like a textbox or chart, you can activate a cell behind one of them when the sheet opens. You won't see any activated cells then
Right click a Sheet1 tab, select view code & past the code below in. Insert a textbox over J5, click somewhere on the sheet so you see the horrendous black outline , click another sheet tab & then click Sheet1 tab & the activated cell is hidden

Please Login or Register  to view this content.

ok that's great and that does work.

thanks,

however, I was wondering if it was possible to never have it appear. e.g. that works, but when I then click on cell it appears again.

is there a way I can code it so that if I click a1 - that box appears around aa1? and drag it down.. so that anything I click it doesn't appear (well it does but off screen)

obviously it wouldn't be like this.. but to generalise. e.g.

if a1 is clicked. aa1 shows selction border.

I wouldn't think so, though you could activate the cell behind a chart after any event has happened on the sheet.

Maybe not any event but just in the double clic event …

I guess ive reached the conclusion that many other above reached before me - its not worth the hassle lol

cheers guys