How do I edit a worksheet that has been defined as an addin

[Guy Normandeau]

I created several functions that I re-use. I saved them in an addin along
with data on two worksheets. How do I edit the contents on the sorkwheets.
When ever I open the addin, the worksheet is not present.

Thanks in advance for your help.

Guy Normandeau

[Bob Phillips]

Addin worksheets are de-facto hidden, still there, but not visible. So you
can't edit in Excel, but you can in VBA

Workbooks("myAddin".xla").Worksheets("data").Range("A1").Value = "hello"

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Guy Normandeau" <GuyNormandeau@discussions.microsoft.com> wrote in message
news:E46E3160-A13D-4297-A3AE-1E64E203751F@microsoft.com...
> I created several functions that I re-use. I saved them in an addin along
> with data on two worksheets. How do I edit the contents on the
sorkwheets.
> When ever I open the addin, the worksheet is not present.
>
> Thanks in advance for your help.
>
> Guy Normandeau

[Gord Dibben]

Guy

From a Chip Pearson post..........

You can edit the XLA just like you can edit the XLS.

For edits to VBA code, you can simply edit the
VBA as normal.

If you need to edit anything in a worksheet, simply change the IsAddIn property
to False and the workbook and the worksheets will be visible.

End Chip..................................


Gord Dibben MS Excel MVP

On Tue, 20 Jun 2006 06:54:01 -0700, Guy Normandeau
<GuyNormandeau@discussions.microsoft.com> wrote:

>I created several functions that I re-use. I saved them in an addin along
>with data on two worksheets. How do I edit the contents on the sorkwheets.
>When ever I open the addin, the worksheet is not present.
>
>Thanks in advance for your help.
>
>Guy Normandeau

[Guy Normandeau]

Perfect!

This is exactly what I was looking for.

Thanks Gord.

"Gord Dibben" wrote:

> Guy
>
> From a Chip Pearson post..........
>
> You can edit the XLA just like you can edit the XLS.
>
> For edits to VBA code, you can simply edit the
> VBA as normal.
>
> If you need to edit anything in a worksheet, simply change the IsAddIn property
> to False and the workbook and the worksheets will be visible.
>
> End Chip..................................
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 20 Jun 2006 06:54:01 -0700, Guy Normandeau
> <GuyNormandeau@discussions.microsoft.com> wrote:
>
> >I created several functions that I re-use. I saved them in an addin along
> >with data on two worksheets. How do I edit the contents on the sorkwheets.
> >When ever I open the addin, the worksheet is not present.
> >
> >Thanks in advance for your help.
> >
> >Guy Normandeau
>
>