Try Tools Macro RecordNewMacro and follow the menus and then actually
hide the columns you wish for one instance by hand and then stop
recording....you now have a macro to do that action again any time you need
it.....then do the same to clear all the hidden columns, and a third macro to
hide the other set of columns.....if you have trouble, post back.....

hth
Vaya con Dios,
Chuck, CABGx3



" wrote:

I'm creating a wookbook where each row is indentified to a different
project as well as two columns and two work sheets. I need to hide the
rows, columns and worksheet for project A when viewing project B and
vis versa. I would like to create a macro to do this but I'm running
out of ideas. Can any one out there help?

Please note I am experienced in Excel but it is from hands on
experience so some highly technical terms may confuse me.

Thanks
Treen