Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to Anne and others who do not put info in the message section
the system will not let me reply to some messages, especially those wtih
nothing in the message section. Please repost with something I can respond to. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
to Anne and others who do not put info in the message section
My question is how can I get the home tab to always go back to the same cell
in the worksheet? "bj" wrote: the system will not let me reply to some messages, especially those wtih nothing in the message section. Please repost with something I can respond to. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
to Anne and others who do not put info in the message section
You can use something like the OnKey method in VBA:
Sub ChangeHome() Application.OnKey "{Home}", "SelectIt" End Sub Sub SelectIt() Range("A25").Select End Sub You can put the ChangeHome Macro in a WorkBook_Open() procedure will run on opening the workbook. To change it back use: Sub EndIt() Application.OnKey "{Home}" End Sub in a Workbook_BeforeClose macro -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Anne" wrote in message ... My question is how can I get the home tab to always go back to the same cell in the worksheet? "bj" wrote: the system will not let me reply to some messages, especially those wtih nothing in the message section. Please repost with something I can respond to. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
to Anne and others who do not put info in the message section
Where do you want it to go?
Have you tried <Ctrl <Home? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Anne" wrote in message ... My question is how can I get the home tab to always go back to the same cell in the worksheet? "bj" wrote: the system will not let me reply to some messages, especially those wtih nothing in the message section. Please repost with something I can respond to. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
varying validation info based on preceding info | Excel Discussion (Misc queries) | |||
macro to open outgoing message with info | Excel Discussion (Misc queries) | |||
Tables, How do I make new info push existing info to the next row? | Excel Worksheet Functions | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Sharing Workbook Info message ? | Excel Discussion (Misc queries) |