Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to hide excel?


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

--
Wilb
-----------------------------------------------------------------------
Wilbo's Profile: http://www.excelforum.com/member.php...fo&userid=1008
View this thread: http://www.excelforum.com/showthread.php?threadid=26947

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default How to hide excel?

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
;-)

Wilbo wrote in message
...

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 excel
userinterface that only the calculation programs forms are visible.


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

BR
-Wilbo


--
Wilbo
------------------------------------------------------------------------
Wilbo's Profile:

http://www.excelforum.com/member.php...o&userid=10084
View this thread: http://www.excelforum.com/showthread...hreadid=269472



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you hide/un-hide the grid lines ED Excel Discussion (Misc queries) 4 February 26th 13 03:22 PM
Want to Hide columns in spreadsheet but NOT hide data in chart. KrispyData Charts and Charting in Excel 1 March 20th 09 04:45 PM
How do I hide hide #REF! in Excel PerryK Excel Discussion (Misc queries) 3 February 27th 09 02:59 PM
How do I hide a worksheet in Excel and use a password to un-hide . Dchung Excel Discussion (Misc queries) 3 December 2nd 04 06:24 AM
Hide Excel row in VBA RichC[_2_] Excel Programming 3 April 7th 04 03:57 PM


All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"