Solved

VSTO 2005 - Making managed spreadsheet visible

Posted on 2006-11-20
3
219 Views
Last Modified: 2013-12-03
Hi

In my VSTO 2005 project at startup I make the
spreadsheet part invisible using
Application.Visible = False

I have Windows form with a button on it that
I want to show the managed spreadsheet with.
How do I do this as
Application.Visible = True does not work
0
Comment
Question by:murbro
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
newyuppie earned 500 total points
ID: 17980197
what if you hide the worksheet instead of the entire application?

CType(Globals.ThisWorkbook.Sheets(1), Excel.Worksheet) _
    .Visible = Excel.XlSheetVisibility.xlSheetHidden

and to unhide
CType(Globals.ThisWorkbook.Sheets(1), Excel.Worksheet) _
    .Visible = Excel.XlSheetVisibility.xlSheetVisible
0
 

Author Comment

by:murbro
ID: 17987618
Thanks very much again. Spot on :)
0
 
LVL 13

Expert Comment

by:newyuppie
ID: 17987883
thanks for the points, glad it worked out for you!
NY
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question