Worksheet Focus
 

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!)

Worksheet Focus
 

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!)

Worksheet Focus
 

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!)

Worksheet Focus
 

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!)

Worksheet Focus
 

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!)

Worksheet Focus
 

Hi Tom,

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

A wonderfully evocative quotation!

---
Regards,
Norman


"Tom Ogilvy" wrote in message
...
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

Worksheet Focus
 

You sure it wasn't "Old Yeller"....




Tom Ogilvy wrote:

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!)







--

Dave Peterson

Worksheet Focus
 

It could have been, but Old Yeller really couldn't grab ahold so it seems
less likely. Of couse I was only around 8 back then, so may have missed it
or may have been up getting popcorn during that part. Then again, they tend
to reuse the really good lines.

--
Regards,
Tom Ogilvy





"Dave Peterson" wrote in message
...
You sure it wasn't "Old Yeller"....




Tom Ogilvy wrote:

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!)







--

Dave Peterson

Worksheet Focus
 

Off to check IMDB.com.

Nope, I must be wrong <vvbg.

Tom Ogilvy wrote:

It could have been, but Old Yeller really couldn't grab ahold so it seems
less likely. Of couse I was only around 8 back then, so may have missed it
or may have been up getting popcorn during that part. Then again, they tend
to reuse the really good lines.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
You sure it wasn't "Old Yeller"....




Tom Ogilvy wrote:

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!)







--

Dave Peterson

--

Dave Peterson