Do you mean sheets (within a workbook), or all workbooks in a folder?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Pascale" wrote in message
...
Brilliant It works! However, I want to be able to use this macro with all
my
spreadsheets, can you please tell me how to not have this macro attached
to a
specific spreadsheet but be accessible to all spreadsheets opened or not?
thanks. Pascale

"Bob Phillips" wrote:


Columns("H:J").Delete
Columns("M:O").Hidden = True

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Pascale" wrote in message
...
Hello
I have done very basic macros using "tools" and "record new macro". I
need
to create one that will delete some columns and hide others. How can I
do
this please?
Many thanks. I am working on excel 2003.