Solved - Excel 2007 Encryption Not Available
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.
|