S Stuart Mar 10, 2005 #1 Is it possible to display a sheet from a loaded addin, allow access to the sheet, then 'hide' it again, please? Regards.
Is it possible to display a sheet from a loaded addin, allow access to the sheet, then 'hide' it again, please? Regards.
T Tom Ogilvy Mar 10, 2005 #2 You could copy it to a new workbook, then copy the information back and close the workbook without saving. As you might have noted, sheets which are visible when you convert the workbook to an addin, are not visible - so that might tip you off.
You could copy it to a new workbook, then copy the information back and close the workbook without saving. As you might have noted, sheets which are visible when you convert the workbook to an addin, are not visible - so that might tip you off.
B Bob Phillips Mar 10, 2005 #4 You could always set the IsAddin property of that workbook to False, it all becomes visible then, and then reset back to True at some point. Workbooks("Easyfilter.xla").IsAddin = False -- HTH RP (remove nothere from the email address if mailing direct)
You could always set the IsAddin property of that workbook to False, it all becomes visible then, and then reset back to True at some point. Workbooks("Easyfilter.xla").IsAddin = False -- HTH RP (remove nothere from the email address if mailing direct)
