Is it possible to display a sheet from a loaded addin, allow
access to the sheet, then 'hide' it again, please?

Regards.

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.

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
Is it possible to display a sheet from a loaded addin, allow
access to the sheet, then 'hide' it again, please?

Regards.

Feared as much, but wanted to be sure.

Regards and thanks.

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
Is it possible to display a sheet from a loaded addin, allow
access to the sheet, then 'hide' it again, please?

Regards.

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)


"Stuart" wrote in message
...
Feared as much, but wanted to be sure.

Regards and thanks.

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
Is it possible to display a sheet from a loaded addin, allow
access to the sheet, then 'hide' it again, please?

Regards.