VSTO 2005 - Making managed spreadsheet visible

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
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
newyuppieConnect With a Mentor Commented:
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
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much again. Spot on :)
0
 
newyuppieCommented:
thanks for the points, glad it worked out for you!
NY
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.