View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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