Ok, this is weird and driving me crazy 
I have a spreadsheet that has a list of the items a user has used the UserForms to put in. Part of the data they have to put in is a formula to calculate accessories for some parts.
I don't want to have to hide/unide the column with the formula everytime they run the macro to put in a new piece and I don't want them to see the first digit of the result of the formula so I set the format to white text.
It's not conditional formatting or anything, just normal "make the text here white" formatting.
It looks right on my computer but whenever the foremen open the sheet, the text has changed to black and they get confused by the random number appearing in the supposed to be blank column.
Anyone know why the perfectly normal formatting would disappear when opened on another computer and how I can fix it?
We use excel 2007 if that makes a difference
I have a spreadsheet that has a list of the items a user has used the UserForms to put in. Part of the data they have to put in is a formula to calculate accessories for some parts.
I don't want to have to hide/unide the column with the formula everytime they run the macro to put in a new piece and I don't want them to see the first digit of the result of the formula so I set the format to white text.
It's not conditional formatting or anything, just normal "make the text here white" formatting.
It looks right on my computer but whenever the foremen open the sheet, the text has changed to black and they get confused by the random number appearing in the supposed to be blank column.
Anyone know why the perfectly normal formatting would disappear when opened on another computer and how I can fix it?
We use excel 2007 if that makes a difference
