View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Are Protection Options Compatible?

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