Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Visual Basic Apps for Excel (worksheet visibility)

Status
Not open for further replies.

ORC

Programmer
May 3, 1999
1
0
0
US
Using VB Apps I've created a spreadsheet, which allows the user to make some choices (via check boxes), click a button and the result of some simple calculations is displayed.<br>
<br>
The problems is this:<br>
<br>
(1) I would like to keep the calculation worksheets invisible, but it seems VB needs them to be visible to use them. Does anyone know of a way around this?<br>
<br>

 
ExcelApp.Application.Visible = False<br>
This will prevent the app to be visible<br>
Application.Interactive = False<br>
This prevent the user from interacting with the session of Excel you openned<br>
<br>
Hope this helps
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top