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

G

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
 
B

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

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
 
Top