Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ScreenUpdating "peephole"
Hi,
For cosmetic reasons, is there a way to use ScreenUpdating False, at the Range level, in order to be able to intersect with ActiveCell ... And then have ActiveCell in another workbook ... This would allow a kind of "peephole" in the screen .. Thanks a lot for your suggestions Cheers Carim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ScreenUpdating "peephole"
I don't really understand what you are trying to accomplish, but
ScreenUpdating is a global setting. It applies to all cells and all workbooks. You can't have ScreenUpdating = False for all cells but one. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Carim" wrote in message oups.com... Hi, For cosmetic reasons, is there a way to use ScreenUpdating False, at the Range level, in order to be able to intersect with ActiveCell ... And then have ActiveCell in another workbook ... This would allow a kind of "peephole" in the screen .. Thanks a lot for your suggestions Cheers Carim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ScreenUpdating "peephole"
Chip,
Thanks a lot for your answer ... and sorry for not being clear ... My constraint is to have a user update a database workbook, while remaining in the original workbook ... BUT having the possibility to see his change in the activecell ... of the database workbook ... At this stage, I am working on the routine you developped to mimic the camera tool ... but I have not managed to create a hole in the picture .... (for the active cell) since the procedure apparently requires a standard range (not a rebuilt one...) Thanks a lot for your insight Cheers Carim |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ScreenUpdating "peephole"
Chip,
Please do not bother to look further into this question. Indeed, thanks to you and to your routine which replicates the camera tool and also thanks to the Excel oddities : http://www.j-walk.com/ss/excel/odd/odd04.htm I have managed to create a test "peephole" which works fine ... Again, thanks for the inspiration ... A great fan of yours ... and of your superb site !!! Cheers Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Application.Screenupdating not "always" working? | Excel Programming |