Good morning, All:

I have a scheduling workbook with several sheets that I created in
Excel 2003. The person who is to enter data into it is operating using
Excel 2000. The first three columns (A-C) have information that is to
be printed each day. After that, every four columns represents a
different day of the week. I've put protection on all of the cells
that contain formulas, and have set the permission for those cells to
include formatting, so that the person who enters data is able to hide
and reveal columns for printing purposes (e.g. he hides the data for
Monday when he wants to just print Tuesday). This kind of permission
works on Excel 2003, but when I went to check his settings on Excel
2000, there are only three options for permission: protect for
contents, objects and one other (can't remember the title).

Is there a way to do one of the following:
1. Write VBA code or a macro to allow him to hide the columns (i.e.
that overwrite the protection criteria in Excel 2000) but still protect
the formulas in the cells?
2. Write VBA code or a macro to hide the appropriate area depending on
the day (e.g. on Tuesday, print columns A-C and H-K, on Wednesday,
print columns A-C and J-M)?

Any help is greatly appreciated.

-Achez