Hi,

1. Protection is backwards compatible, if the type of protection was
available in the previous version.
2. If the spreadsheet is in 2007 and the user tries to open it in 2003
without the compatiblility feature, I don't think the file will even open.
3. You can write code to block many actions, but it may be quite complex
because there are usually many ways to do something. Additionally, you need
to consider that macros need to be enabled.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Reitanos" wrote:

If I set Protection Options (ie prevent insert rows) in Excel 2007,
will those options be honored when saving a workbook in a previous
version format? How about if I save it as Excel 2007 and they open it
with MS's compatibility tool?

Other than protection, is it possible to use a macro to deny access to
a particular command?

Thanks.