format "focus" characteristics

  • Thread starter Thread starter Pa Maher
  • Start date Start date
P

Pa Maher

The cell on which the focus rests is indicated by a thick box outline.
Is there a way to thin those lines?
Are the other formating features that can indicate focus?
 
Thanks Dave,
The add-in allows for some efficient and attractive features,
however it seems to nullify the
Application.ScreenUpdating = False
code which I need since I go to other sheets to copy comments
and record answers, and want to avoid the flickering.
 
I've never used Chip's utility (except a long time ago to see how it worked).

I bet your code could be rewritten to avoid the screen updating.

Instead of
sheets("somesheetname").select
range("b99").select
selection.copy
sheets("someothersheetname").select
range("x234").select
activesheet.paste

you may be able to use:

sheets("someothersheetname").range("x234").value _
= sheets("somesheetname").range("b99").value

But that's just a guess.
 
Back
Top