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

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

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

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

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

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
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

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

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
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