| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!) |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set Focus to Worksheet and then a specific ROW | Excel Programming | |||
| Maintain focus on one worksheet while collecting data in others | Excel Programming | |||
| Option Button/Focus Problem on Worksheet | Excel Programming | |||
| Vying for the focus - Worksheet Vs Forms | Excel Programming | |||
| Set focus on graphic inserted in worksheet | Excel Programming | |||
Linear Mode
