LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Locking Down Workbooks Properly & Disabling Functionality

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disabling formula recalculation when opening or closing workbooks Joe Excel Discussion (Misc queries) 3 August 5th 08 09:24 PM
Sumproduct wont update properly on closed workbooks vane0326 Excel Worksheet Functions 0 August 17th 06 03:26 PM
Shared Workbooks Locking Up rastus Excel Discussion (Misc queries) 0 July 19th 05 09:24 PM
locking workbooks Nick Excel Discussion (Misc queries) 0 July 6th 05 02:32 PM
The colors should work properly in Shared Excel Workbooks. [email protected] Excel Worksheet Functions 1 November 8th 04 10:55 PM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"