Enable Formula Audting in an Excel Workbook where all the sheets are protected

VBA , Excel , protecting worksheets London, United Kingdom
  • 11 years ago


    I have written a macro that protects all the worksheets in the workbook but I need to allow the user to use the Formula Auditing features after the sheets are protected. I have tried setting .EnableSelection = xlnoRestrictions but that hasn't worked. Can anyone suggest a way to do this? Is it even possible?


Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Beware of bugs in the above code; I have only proved it correct, not tried it.” - Donald Knuth