What need I do to display as the active sheet, sheet1 of an addin froma macro within the addin?
Create a macro inside the add-in with this single line of code.ThisWorkbook.IsAddin = FalseI would also suggest creating one that reverse this . . .ThisWorkbook.IsAddin = trueAssign each to a separate toolbar button and you should be set.
I do have afollowup. Excel thinks it has to save the add-in after I do somework and on exit asks to save the file. If it gets saved by the userand the property is set to false, the addin will be corrupt. Is therea way to prevent the message?
I did resolve this by setting a workbook property "saved" to true.Thanks for the help.