 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008Display Worksheets from AddIn
Hi, How are the Worksheets displayed from an AddIn? When AddIn in added, I've created a custom menu which when selected calls a Subroutine in the file which assumes that the Worksheets are open but it's not and I'm getting errors...thanks. Hi Groupie, An add-in's worksheets are hidden. To unhide the sheets, you would have to change the add-in's IsAddin poperty to False. either manually( in the Explorer window of the VBE : select the ThisWorkbook module and hit F4 to open the properties window) or by code. However, this causes the addin to revert to a standard workbook, which Isuspect is not what you want. Perhaps, explain in a little more detail what you are endeavouring to achieve, and you will find many here ready to help, --- Regards. Norman > Hi, > How are the Worksheets displayed from an AddIn? When AddIn in added, > I've created a custom menu which when selected calls a Subroutine in > the file which assumes that the Worksheets are open but it's not and > I'm getting errors...thanks. On May 27, 5:07 pm, "Norman Jones" <normanjo...@wherforartthou.com> wrote: > Hi Groupie, > [quoted text clipped - 26 lines] > > - Show quoted text - Hi, Thanks for the reply. Hopefully this clarifies the situation: I'm trying to distribute my Excel file (contains 2 sheets and VBA coding) to end-users via an addin. So the core of the problem is that the OnAction command of a custom menu item, created when the Excel file is added as an AddIn, calls a custom subroutine which works on the worksheets of the excel file. However the worksheets are not displayed when the user selects the custom menu item. i.e. it seem sthat the excel form is not being displayed. Hope this clarifies the problem. Thanks. Addin worksheets are always hidden and never active. You can refer to them in code using something like Thisworkbook.worksheets("Sheet1").Range("B4:z99") Usually the worksheets in an addin are used to store things like Formats and constants that are used by the addin to create /modify sheets in the active workbook, or are used as Template sheets to be copied into the active workbook. regards Charles __________________________________________________ The Excel Calculation Site http://www.decisionmodels.com On May 27, 5:07 pm, "Norman Jones" <normanjo...@wherforartthou.com> wrote: > Hi Groupie, > [quoted text clipped - 30 lines] > > - Show quoted text - Hi, Thanks for the reply. Hopefully this clarifies the situation: I'm trying to distribute my Excel file (contains 2 sheets and VBA coding) to end-users via an addin. So the core of the problem is that the OnAction command of a custom menu item, created when the Excel file is added as an AddIn, calls a custom subroutine which works on the worksheets of the excel file. However the worksheets are not displayed when the user selects the custom menu item. i.e. it seem sthat the excel form is not being displayed. Hope this clarifies the problem. Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.