Is Mac Office 2010 out yet? Has Microsoft released a patch for Mac Office that will renable VBA yet? Office 2008 sucks!
Ok, with that off my chest, here is the problem.
I have Date columns (Jan -> Dec) each of which is full of formulas. I need
the user to be able to Filter the contents of each column but NOT be able to over write the contents of the formulas.
To be able to filter, I applied a Data, Filter to each column.
But, ....
This works AS LONG AS I DON'T TURN ON WORKSHEET PROTECTION. When I do that, I am unable to access the Filters in each date column. (Yes I 'unlocked' each date column header).
Got any ideas? (Remember I am running a crippled version of XL... no VBA.)
Thanks
Ron
Ok, with that off my chest, here is the problem.
I have Date columns (Jan -> Dec) each of which is full of formulas. I need
the user to be able to Filter the contents of each column but NOT be able to over write the contents of the formulas.
To be able to filter, I applied a Data, Filter to each column.
But, ....
This works AS LONG AS I DON'T TURN ON WORKSHEET PROTECTION. When I do that, I am unable to access the Filters in each date column. (Yes I 'unlocked' each date column header).
Got any ideas? (Remember I am running a crippled version of XL... no VBA.)
Thanks
Ron
