hmmm, "palliative" eh.

Wasn't it in the Shawshank Redemption where Bubba spoke that immortal
phrase:

"Bend over and grab ahold of them thar screaming bars to palliate your
discomfort"

--
Regards,
Tom Ogilvy


"Norman Jones" wrote in message
...
Hi Paul,

if you set screen updating to false would this acccomplish the same
thing??
No, setting ScreenUpdating to False does not prevent selections and does
nothing to ensure that the required sheet remains, or becomes the active
sheet; it merely prevents the screen from being redrawn, thus rendering
such
selections invisible.

Tom's suggestion was to remove unnecessary selections and represented a
solution; disabling ScreenUpdating provides a visual palliative to a
concomitant problem of selections, but does nothing to resolve the OP's
intrinsic problem.


---
Regards,
Norman


"paul" wrote in message
...
if you set screen updating to false would this acccomplish the same
thing??
--
paul
remove nospam for email addy!



"Tom Ogilvy" wrote:

Unless you code moves the focus from this sheet, it will not change.

Instead of code like

Worksheets("Sheet2").Activate
Range("B9").Select
Selection.copy
Worksheets("Sheet3").Activate
Range("F2").Select
Activesheet.Paste

do colde like

Worksheets("Sheet2").Range("B9").copy _
Destination:=Worksheets("Sheet3").Range("F2")

The point is to avoid selecting. Use references to ranges.

--
Regards,
Tom Ogilvy


"Zani" wrote in message
...
Hello clever people!

I have a project which collects and writes information to various
worksheets
within the file, what I would like to do is keep the focus on the
"front
cover" sheet. The front cover sheet has the links to all the
userforms
etc
to run, but I would like to keep the focus set on this sheet so it
looks
pretty for the users!

I'm am sure there is an easy way to do this but I can't for the life
of
me
find it - maybe it's just too late in the day!

--
Zani
(if I have posted here, I really am stuck!)