Hi,

I have a spreadsheet which I am looking to distribute to a few people.

It basically tracks stock prices and works out portfolio value and tax implications.

The spreadsheet has code and data, and I want to know the best way to arrange it so that I can upgrade the code later if need be, without overwriting the data.

I suppose I need to split the two up, using an add-in?

What is the best way to do this please.

Thanks
Rich

Rich,

The best approach would be to put all the code in an Add-In.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Rich" wrote in message
...
Hi,

I have a spreadsheet which I am looking to distribute to a few
people.

It basically tracks stock prices and works out portfolio value
and tax implications.

The spreadsheet has code and data, and I want to know the best
way to arrange it so that I can upgrade the code later if need
be, without overwriting the data.

I suppose I need to split the two up, using an add-in?

What is the best way to do this please.

Thanks
Rich

Thanks Chip,

I have realised another part of the problem is the formulas that are
throughout the workbook. There may be a need to upgrade those.

BTW, all my complex array formulas are based on your site, just made the
connection.

Thanks!!!!!!

"Chip Pearson" wrote in message
...
Rich,

The best approach would be to put all the code in an Add-In.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Rich" wrote in message
...
Hi,

I have a spreadsheet which I am looking to distribute to a few
people.

It basically tracks stock prices and works out portfolio value
and tax implications.

The spreadsheet has code and data, and I want to know the best
way to arrange it so that I can upgrade the code later if need
be, without overwriting the data.

I suppose I need to split the two up, using an add-in?

What is the best way to do this please.

Thanks
Rich

Yes, you are on the right track. An add-in is the way to go. For some
pointers see http://www.mrexcel.com/board2/viewtopic.php?p=148963#
148963

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <41f6b7bb$0$10536$5a62ac22@per-qv1-newsreader-
01.iinet.net.au, says...
Hi,

I have a spreadsheet which I am looking to distribute to a few people.

It basically tracks stock prices and works out portfolio value and tax implications.

The spreadsheet has code and data, and I want to know the best way to arrange it so that I can upgrade the code later if need be, without overwriting the data.

I suppose I need to split the two up, using an add-in?

What is the best way to do this please.

Thanks
Rich