How to hide excel?

  • Thread starter Thread starter Wilbo
  • Start date Start date
W

Wilbo

Hi,

Is it possible to hide the excel view? I've done a calculation program
which userinterface is done by VBA forms. Now, i'd like to hide exce
userinterface that only the calculation programs forms are visible.


Another question is that how can I use the excel print preview with th
forms? User forms are allways on the top and the print preview i
disabled.

BR
-Wilb
 
Hi Wilbo
Either of the following are options for hiding your sheet

Application.Visible = False
or
Windows(ThisWorkbook.Name).Visible = False

An easy way is to change the ShowModal property of the form to False
But if the Application or Window are hidden there's nothing to print?

Happy Friday
;-)
 

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

hiding the headers 1
Hide Excel Window 1
Floating text 1
To protect user's privacy 1
hide cells 3
Disabled all print option on Excel 2003 shared add-in vs 2005 1
How to disable and hide ALL menu in Excel 2007? 2
Programmatically hide an object - Excel 2003 or 2007 1

Back
Top