I use hide window when the application is userform driven, it removes the
sistration of any changes to the underlying sheet, however be aware that in
this situation there is no active workbook, worksheet, ranges or cells etc.,
References must be fully defined.

You must use: workbooks(index).worksheets(index).range(...... etc. else
the calls will fail. Assignment to a an object is the best way forward.

Cheers
Nigel


"Tetsuya Oguma" <Tetsuya wrote in message
...
Hi all,

I have this simple question. From Excel 2002 and later you can hide Window
(go to WIndow|Hide on MenuBar). What is this for? I read somewhere, along
the
line of "If you want your users to look into code ONLY you may use this
feature."

Can anyone tell me how to use this best?

Cheers,
---
Tetsua Oguma, Sydney, Australia