software

Microsoft Office Excel 2003. I have been trying desperately to find the
following info:

a) how the macros get data from the reference tables
b) how to find these tables which seem to be hidden from users
c) how to change some of the values used by the macros for calculations
d) how to find out which macro uses what table for these calculations

Can anyone help?

Do you have a specific workbook in mind or just in general.

Are you sure you have macros?

Maybe just formulas referring to hiden sheets or ranges.

Tell us the name of the workbook and where you got it from(if downloaded, give
us a URL)Gord Dibben MS Excel MVP

On Thu, 19 Jan 2006 13:40:03 -0800, quot;Kitchen Tune Up - Marioquot; lt;Kitchen Tune Up -
gt; wrote:

gt;Microsoft Office Excel 2003. I have been trying desperately to find the
gt;following info:
gt;
gt;a) how the macros get data from the reference tables
gt;b) how to find these tables which seem to be hidden from users
gt;c) how to change some of the values used by the macros for calculations
gt;d) how to find out which macro uses what table for these calculations
gt;
gt;Can anyone help?Thanks for the response. We are trying to unhide the referencetables from an
internal quoting program at our company that is in Excel format. We want to
change some of the values .
quot;Gord Dibbenquot; wrote:

gt; Do you have a specific workbook in mind or just in general.
gt;
gt; Are you sure you have macros?
gt;
gt; Maybe just formulas referring to hiden sheets or ranges.
gt;
gt; Tell us the name of the workbook and where you got it from(if downloaded, give
gt; us a URL)
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Thu, 19 Jan 2006 13:40:03 -0800, quot;Kitchen Tune Up - Marioquot; lt;Kitchen Tune Up -
gt; gt; wrote:
gt;
gt; gt;Microsoft Office Excel 2003. I have been trying desperately to find the
gt; gt;following info:
gt; gt;
gt; gt;a) how the macros get data from the reference tables
gt; gt;b) how to find these tables which seem to be hidden from users
gt; gt;c) how to change some of the values used by the macros for calculations
gt; gt;d) how to find out which macro uses what table for these calculations
gt; gt;
gt; gt;Can anyone help?
gt;
gt;

Mario

Data can be in hidden worksheets or hidden ranges.

Check the formulas you can see to find out what sheets and ranges they
reference.

Also check out Insertgt;Namesgt;Define to see if you have names for ranges that may
be hidden.

If data not personal or sensitive, send me the file and I'll have a look at it.

To email me change the AT and DOT to the appropriate punctuation.

Do not attach files in postings to the news group.Gord

On Thu, 19 Jan 2006 15:31:02 -0800, quot;Kitchen Tune Up - Marioquot;
gt; wrote:

gt;Thanks for the response. We are trying to unhide the referencetables from an
gt;internal quoting program at our company that is in Excel format. We want to
gt;change some of the values .
gt;quot;Gord Dibbenquot; wrote:
gt;
gt;gt; Do you have a specific workbook in mind or just in general.
gt;gt;
gt;gt; Are you sure you have macros?
gt;gt;
gt;gt; Maybe just formulas referring to hiden sheets or ranges.
gt;gt;
gt;gt; Tell us the name of the workbook and where you got it from(if downloaded, give
gt;gt; us a URL)
gt;gt;
gt;gt;
gt;gt; Gord Dibben MS Excel MVP
gt;gt;
gt;gt; On Thu, 19 Jan 2006 13:40:03 -0800, quot;Kitchen Tune Up - Marioquot; lt;Kitchen Tune Up -
gt;gt; gt; wrote:
gt;gt;
gt;gt; gt;Microsoft Office Excel 2003. I have been trying desperately to find the
gt;gt; gt;following info:
gt;gt; gt;
gt;gt; gt;a) how the macros get data from the reference tables
gt;gt; gt;b) how to find these tables which seem to be hidden from users
gt;gt; gt;c) how to change some of the values used by the macros for calculations
gt;gt; gt;d) how to find out which macro uses what table for these calculations
gt;gt; gt;
gt;gt; gt;Can anyone help?
gt;gt;
gt;gt;