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

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

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

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