Is it possible to disable the "Trace Dependents" popup, which alerts me that "The Trace Dependents command found no formulas that refer to the active cell".
I want a nice beep instead of the rather annoying popup box..
-thanks
Is it possible to disable the "Trace Dependents" popup, which alerts me that "The Trace Dependents command found no formulas that refer to the active cell".
I want a nice beep instead of the rather annoying popup box..
-thanks
Hi
Would this help
sub auto_open
Application.DisplayAlerts = False
Beep
End Sub
Hi,
Thanks for the input. Sadly, it didn't do the trick..
Regards,
-Tracy
Hi Tracy
Not sure if this will work, but you can try this
Private Sub Workbook_Open()
Application.CommandBars("Worksheet Menu Bar").Controls("Tools").Controls("Auditing").Enabled = False
End Sub
Private Sub Workbook_Close()
Application.CommandBars("Worksheet Menu Bar").Controls("Tools").Controls("Auditing").Enabled = True
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks