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.

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.

What previous version of excel is going to open the file?

xl2002+ (IIRC) has that level of sheet protection.

xl2k and below won't support it.

I don't know about the compatibility pack.

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.

--

Dave Peterson

As for part 2, maybe...

It would depend on how much time you want to invest and what the particular
command is.

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.

--

Dave Peterson