Maybe...

Tools|protection|Protect sheet

If you're using xl2002+, don't select the option that lets the users change
formatting.

Scott wrote:

I would like to protect the worksheets from changing the formats. Can
someone advise how to accompany it.

Thanks,

Scott

--

Dave Peterson