Ignore "inconsistent formula" vba

Hi,

I am sending a wb some colleagues, though i have my inconsistent formula turned off on my PC, they wont on theres, can i run that into a module, so that those annoying warnings are turned off on opening the spreadsheet

Thanks
Seamus2626Asked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
You can run a loop for specific ranges and errors:

Sub IgnoreInconsistentFormulas()
Dim cell as Range
for each cell in selection
 cell.errors.item(xlInconsistentFormula).ignore = true
 next cell
End Sub

Open in new window


for example.
0
 
Seamus2626Author Commented:
But i need them to be turned back on exiting the spreadsheet
0
 
Seamus2626Author Commented:
Thanks!
0
All Courses

From novice to tech pro — start learning today.