Assuming that you're clicking OK and not Cancel after changing the
settings, then I don't know what is causing that behavior.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


cliffhanger79 wrote:

> No its not that.
>
> I changed the header information on one sheet, press ok, Looked at
> another sheet then went back to the sheet which I changed the header
> and it read the original information.
>
> Cliffhanger79
>
>