There's a handful of formatting options you see when you do
Tools|protection|protect sheet.

Record a macro when you toggle the ones you want and you'll see the code you
need.

"Darrell_Sarrasin via OfficeKB.com" wrote:

Just realized this will not let me do formatting now. what is code to turn
formatting on?

Darrell_Sarrasin wrote:
thanks those are the only two that have a password thanks!!!

Since there are only two sheets, you could do:

[quoted text clipped - 23 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200809/1

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200809/1

--

Dave Peterson