Hi,

I have created a workbook that restricts specified users from accessing options. This has worked fine for a number of months. However, this week one user (with permissions) has unprotected the workbook/worksheet, made changes to and saved it. When the workbook was re-opened, they found that some features were now unavailable to them. These include the 'Protect' and 'Macro' options from 'Tools'.

I did wonder whether two or more persons were (attempting to) edit the same workbook at the same time, any ideas what else could cause this to happen?

Thanks in advance,


Neal

A Northern Soul

__________________
Neal

A Northern Soul

I would imagine that some code has switched off these functions. You would need to post your code from the workbook, especially anything that mentions Menu or Commandbars.

Hope that helps

Roy