Roy,

Solved the problem by re-ordering the Update_All code. For some reason the last one one, APUHrstocal was reformatting the cells with its calculation. very wierd. This is now run first and the prolem has dissappeared.

The reason behind hiding the sheet hiding is that I could not stop excel going to sheet 1 when the code was being run and then coming back to sheet 2. I want sheet 2 to remain as the active sheet, but the code to still run on sheet 1. I guess my lack of knowledge with selecting sheets has forced me down this route. As for the users, it does not matter if they already have sheet 1 open, but as it is it closes it for them.

JD