Hello there,

I have a large number of spreadsheets each with 12 sheets
named after the abbreviations of months.

I only want my users to be able to see the relevant
month's sheet, ie. if in January hide all the other month
sheets. OR. At least protect the other sheets so they
cannot edit the other sheets figures.

All the spreadsheets will be saved into the same shared
folder.

I'm thinking that maybe there a way of doing this each
month for the multiple workbooks, or have a macro the
runs automatically each month?????

Any input in this will be VERY gratefully received!!

Cheers

Judith