Macro with worksheet

[boodybah]

Hi,
Does anyone know how to save a worksheet within a macro.

I already created a macro and saved it to the excel add ins, I want t
save a worksheet to it so that when the macro works on any sheet it use
data from that saved worksheet in it (as a database)?

Hope it is clear...

 

[jack_n_bub]

Hi,
Does anyone know how to save a worksheet within a macro.

I already created a macro and saved it to the excel add ins, I want t
save a worksheet to it so that when the macro works on any sheet it use
data from that saved worksheet in it (as a database)?

Hope it is clear...!

Hi,

Put the worksheet in your addin. To do this open the workbook (the .xls
version of the addin) and put the worksheet there. Save the workbook an
convert it to addin again. Replace this addin with the existing one.

You can then write code/formulas that takes an argument from the ope
workbook and compares it with the worksheet saved within your addin
Does this make sense?

If you are not sure, please share the sample addin and what you want t
do with it and I can sort it out for you.

Thank You,
Prashan