Locking Down Workbooks Properly & Disabling Functionality

  • Thread starter David-Melbourne-Australia
  • Start date


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,

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question