Use personal.xls as lookup sheet?

L

lk

Hi guys,

Can anyone give me any comments against using the personal.xls sheet as a
place to store lookup tables?

I will not be distributing spreadsheets accessing these tables to anyone
else.

The tables will be income tax tables which will be references from other
workbooks on my local hard drives.

Thanks

Frigid Digit
 
D

Dave Peterson

Just a personal <bg> opinion...

I wouldn't do it.

It would clutter my workbook. If I had to change the table, it would be too
easy to mess up my real personal.xls file.

Why not just use a dedicated workbook/addin that contains the table?

It just seems a little safer to me.

And when you're done with the project(?), you don't have anything to clean
up--just move it or uncheck it from the Tools|Addins menu.
 
B

Bob Phillips

Dave Peterson said:
And when you're done with the project(?), you don't have anything to clean
up--just move it or uncheck it from the Tools|Addins menu.
Click to expand...

When do you ever finish with tax tables Dave? :)
 
D

Dave Peterson

End of the fiscal year???

But if it never is finished, it might even be more important to keep it separate
from personal.xls.

This might be even more important if the OP wants to share that workbook with
others. I wouldn't want to overwrite their personal.xls to give them the table.
 
B

Bob Phillips

To quote the OP ...

I will not be distributing spreadsheets accessing these tables to anyone
else.

Bob

(remove nothere from email address if mailing direct)
 
D

Dave Peterson

I've started that way, too <vbg>.

Bob said:
To quote the OP ...

I will not be distributing spreadsheets accessing these tables to anyone
else.

Bob

(remove nothere from email address if mailing direct)
Click to expand...
 
L

lk

Thanks for the responses guys!!

Decided to keep a backup of my original personal.xls with all VBA code
intact before I transfer my tax tables. I figured I could always remove the
sheets if I do ever decide to give the file to someone else.

Have a good weekend.

LK
 
Top