+ Reply to Thread
Results 1 to 3 of 3

How to view addin's worksheet?

  1. #1
    Registered User
    Join Date
    04-08-2009
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    85

    How to view addin's worksheet?

    I'm stuyding the book "Professional Excel Development" which has a Project Template and an addin with several modules and a worksheet. I can view the addin's modules but not it's worksheet - is this normal for addin's? I haven't worked with them much before. Thanks!
    (Using Excel 2007 and 2000 btw.)
    Last edited by jp001; 05-11-2009 at 08:43 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: How to view addin's worksheet?

    The addins workbook is not visible, this is expected behaviour.

    To see the actual workbook you would need to set the IsAddin property of Thisworkbook object to False. You can do this via the VBE project window.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-08-2009
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    85

    Re: How to view addin's worksheet?

    Thanks for that Andy!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1