Replies

Probably the file opens in Internet Explorer. VBA code in Excel files does not work well when the file is opened in IE.

I am not sure why MS decided to include to so many options given that it is easy enough to create your own on demand.

MS did not include all of the styles you have deleted, they were added to your workbook during copy/paste actions pasting in information from other workbooks.

Copying a worksheet from workbook A to workbook B can have a similar effect.

The fact that your workbook had so many styles proves that it has a very long editing history.

Make sure you use the proper double quotes, it looks like all the opening double quotes ” need to be replaced with “

OPen Office should be able to read your Office XP documents without too much trouble.
However, some formatting will probably turn out different that expected and some Excel functionality may not work in Open Office.

Maybe your IT department has locked you out of that part?

Any hidden rows?

Does it help to do a control+shift+alt+F9 (forces Excel to rebuild the calculation tree)?

This is certainly do-able in Excel VBA. If you can write VB (I assume classic VB), VBA is a no-brainer. Take head that VBA is a subset of VB6 and hence some things aren’t there (especially the forms package is less complete).

If the frequence of readings isn’t too high I see no problem (since you mention “real time”).

Are there formulas pointing to entire columns?
Where does control+end take you on the sheets?

I just counted on a plain new workbook and there are no more than 42 predefined styles. ONE of them is Neutral. So your workbook is definitely “dirty” with styles.
You can right click entries in the styles dropdown to delete them.

Why not include a real-life example? You can still change the product names and such so we don’t know what products this is about.

You could try the Appactivate method.

I’d suggest to do the selecting of the product on the same form as where the color needs to be selected, or to do the entire selecting on the worksheet.

You could simply use data validation to create dropdowns in two adjacent cells.

Update which remembers the toolbar position…

Odd, I could not repro this on a small test document. Could you perhaps upload a sample sheet?

Updated with a beforeprint event to make the arrows go away when printing.