Are Protection Options Compatible?

[Reitanos]

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.

 

[Shane Devenshire]

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.

 

[Dave Peterson]

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.

 

[Dave Peterson]

As for part 2, maybe...

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