Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
return screen view
OK. So here's what I have. I click a cell, and a
selection change macro turns the cell value to "X" or "" (toggles). Then it returns me to like range "B3", or somewhere close to that. The problem is, part of where this "X"ing macro is, may be far off to the right, and I want the user to still be looking at where he clicked, once the new value has been set to "X" or "", but I still want the cell "B3" to be selected. Is there anyway to save where the screen is panned over/up to before the macro and then return it to that same view after? Help is appreciated, as always! Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
return screen view
Bump....
anyone know how to do this? -----Original Message----- OK. So here's what I have. I click a cell, and a selection change macro turns the cell value to "X" or "" (toggles). Then it returns me to like range "B3", or somewhere close to that. The problem is, part of where this "X"ing macro is, may be far off to the right, and I want the user to still be looking at where he clicked, once the new value has been set to "X" or "", but I still want the cell "B3" to be selected. Is there anyway to save where the screen is panned over/up to before the macro and then return it to that same view after? Help is appreciated, as always! Thank you. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen view | Excel Discussion (Misc queries) | |||
view excel in full screen view | Excel Worksheet Functions | |||
HOW FIX EXCEL WHERE PRINT VIEW IS DIFFERENT FROM SCREEN VIEW | Excel Discussion (Misc queries) | |||
on-screen view | Excel Discussion (Misc queries) | |||
same screen view | Excel Discussion (Misc queries) |