ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Update Bottom to start a Macro (https://www.excelbanter.com/excel-discussion-misc-queries/197017-update-bottom-start-macro.html)

pea

Update Bottom to start a Macro
 
Hi
In a worksheet I have a update bottom which runs a macro when I push it. I
use the bottom after I have been editing a cell.
The problem is that I have to push either return er tab to jump out of the
edited cell before the update bottom is active.
Is there a way or procdure so I can make the update bottom active without
first to
have to push returne jumping out of the edited cell, so I just can push the
update bottom vhen I have finished editing the the cell
It's an attemp to make the worksheet as user friendly as possible.
Regards PEA

Bob Phillips[_3_]

Update Bottom to start a Macro
 
Don't think so, you cannot do anything else until you exit edit mode, so
Return or Tab it is.

--
__________________________________
HTH

Bob

"PEA" wrote in message
...
Hi
In a worksheet I have a update bottom which runs a macro when I push it. I
use the bottom after I have been editing a cell.
The problem is that I have to push either return er tab to jump out of the
edited cell before the update bottom is active.
Is there a way or procdure so I can make the update bottom active without
first to
have to push returne jumping out of the edited cell, so I just can push
the
update bottom vhen I have finished editing the the cell
It's an attemp to make the worksheet as user friendly as possible.
Regards PEA





All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com