Change textbox backcolor then save workbook?

Hi

When I try to use the code below the backcolor of the textbox does not change until the workbook is saved. I want the textbox to change colour when the save button has been hit on the userform. I would then have another set of code to change the colour back to its original colour once the workbook has been saved. I can't get any colours to change until the macro finishes running. Is this a timing problem?

Thanks in advance.

Please Login or Register  to view this content.

It is working but the save occurs & changes it to black without you seeing the action, you would need to use a wait command to actually see, unless the save is slow. Try this to see

Please Login or Register  to view this content.

if you go into tools > Options > Calculation, is it set on automatic or manual?
it should be on automatic, to save it to your personal.xls u will need to update something for it to save to your personal.xls