LinkBack URL
About LinkBacks
Hi
I need to disable all kinds of messages that could appear in front of the user when it opens the workbook. I am already using DisplayAlerts=False and On Error Resume Next? Can we also do this through excel application itself and not using VBA ?
Disable all kinds of messages/warnings/alerts in Excel?
Hi
I need to disable all kinds of messages that could appear in front of the user when it opens the workbook. I am already using DisplayAlerts=False and On Error Resume Next? Can we also do this through excel application itself and not using VBA ?
Last edited by hraza; 12-05-2009 at 12:13 PM.
I have never seen it done, why would you want to do that?
Since that workbook will open on a client PC, it needs to log all the errors in a trace file and doesn't show anything to the user as an error !
Oh I know what you are doing , it's just you can't tell excel not to display messages without VBA, like you asked.Originally Posted by hraza
You have mentioned you are using displayAlerts=false, and onerror trapping, are you still getting msgs popping up?,or were you hoping there could be an Excel option not to enable error messages totally?
Yes the messages are still popping up. And yes is there any option to do it through Excel Application rather than vba. Either ways it is bothering me a lot right now !
Re: Disable all kinds of messages/warnings/alerts in Excel?
Ok i have found whats wrong with it
Actually the addin i was using for some data calculation in my workbook was overriding the displayAlerts, hence i had to disable the error message overriding through that addin and the problem solved
CHEERS
Thanks everybody in this thread !
There are some alerts that DisplayAlerts cannot override, i think basically it only works where a user response is required
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks