Excel 2007 Encryption Not Available

tknutsen · #1 02-03-2012, 03:17 PM

I want to protect a workbook - Office 2007 - and Encrypt Document is not available from the Prepare menu. Where can I turn this on?

Thanks
Tim

MarvinP · #2 02-05-2012, 08:50 AM

Hi tknutsen,

Does this site help?
http://www.ehow.com/how_4700901_pass...ect-excel.html

tknutsen · #3 02-29-2012, 05:30 PM

What happend was that I first used the Protect and Share Workbook function and hadn't turned it off. This put the workbook in Shared mode and the encryption function then is not available. Once I turned this off I was able to set the workbook to open with a password using the encryption mode.

Thanks for your post MarvinP but it looks like I didnt explain the problem sufficently.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 to Outlook 2007 - task import possible?	mjwillyone	Outlook	2	07-05-2023 07:23 AM
Method for Password Encryption in word 2010	samdev	Word	9	01-04-2012 10:32 PM
VBA code from Excel 2007 in Excel 2010	csam63	Excel Programming	1	10-07-2011 10:46 AM
Excel 2007 to Word 2007 Labels mail merge not working	rec	Mail Merge	0	07-31-2010 10:45 AM
Encryption XOR - any errors???	Word Doc	Word	1	10-08-2009 12:57 AM