I develop a range of complex Excel models for businesses and provide
completed workbooks to clients with password protection to the point that
they cannot click on areas or copy them off to other workbooks.

However I've just been advised that, using Open Office, users can get around
passwords. Is this correct ?

Basically, I'd like to know whether there are any ways to fully lock down a
workbook so that users cannot access protected areas, copy cells / ranges,
etc.

Also, going back years (being Visual Basic was the macro language !), there
used to be a way of removing / disabling menu options, removing shortcuts,
etc. also to stop users trying to crack into the workings of a spreadsheet.
Are these still possible ? How ? Is there a book or site you know where I
can learn about doing this in Excel 2003 ?

Thanks heaps in advance.

You can slow them down but you can't prevent it.

David-Melbourne-Australia wrote:

I develop a range of complex Excel models for businesses and provide
completed workbooks to clients with password protection to the point that
they cannot click on areas or copy them off to other workbooks.

However I've just been advised that, using Open Office, users can get around
passwords. Is this correct ?

Basically, I'd like to know whether there are any ways to fully lock down a
workbook so that users cannot access protected areas, copy cells / ranges,
etc.

Also, going back years (being Visual Basic was the macro language !), there
used to be a way of removing / disabling menu options, removing shortcuts,
etc. also to stop users trying to crack into the workings of a spreadsheet.
Are these still possible ? How ? Is there a book or site you know where I
can learn about doing this in Excel 2003 ?

Thanks heaps in advance.

Passwords in XL are like locking your car door. It keeps out the honest folk
but does not deter the criminals much. Check out this link...

http://www.mcgimpsey.com/excel/fileandvbapwords.html

As for the second part that is possible...
Here is alisting of siome light reading for you...

http://spreadsheetpage.com/index.php/books/
--
HTH...

Jim Thomlinson


"David-Melbourne-Australia" wrote:

I develop a range of complex Excel models for businesses and provide
completed workbooks to clients with password protection to the point that
they cannot click on areas or copy them off to other workbooks.

However I've just been advised that, using Open Office, users can get around
passwords. Is this correct ?

Basically, I'd like to know whether there are any ways to fully lock down a
workbook so that users cannot access protected areas, copy cells / ranges,
etc.

Also, going back years (being Visual Basic was the macro language !), there
used to be a way of removing / disabling menu options, removing shortcuts,
etc. also to stop users trying to crack into the workings of a spreadsheet.
Are these still possible ? How ? Is there a book or site you know where I
can learn about doing this in Excel 2003 ?

Thanks heaps in advance.