Practical use of Window Hide

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Addin to open and hide a workbook 1
Editorial Innocent Android apps hiding malware 0
Hiding Rows Using IF Statement 1
Windows 10 Windows 10 Is Hiding a Great Video Capture Tool 0
Hiding Columns produces error <----HELP PLEASE 2
Can you "very hide" a workbook? 5
Hide worksheet tab 1
HIDING ROWS AND COLUMS 15

Back
Top