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

• • Reply

  11 years ago

  by raviarul

  Ravi Arulnandhy

  London, United Kingdom

  Joined 11 years ago

  Hi

  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?

  Thanks!

  Report abuse