I'm using Office 2003. I have this code

Application.DisplayAlerts = False
oWS.Copy after:=oWS
Application.DisplayAlerts = True

When I step through the first line, and hover over
Application.DisplayAlerts, it still shows as TRUE. And when the copy
occurs, I get a run time error. The sheet you are copying has more than 255
characters, blah blah blah. I know it does. That's why I do other things
later to capture all of the data. Why am I having DisplayAlerts problems
here?

Thanks,
Barb Reinhardt

Hi,

I can't comment on the runtime error but i'm not surprised hovering over the
line shows displayalerts as TRUE it always does. Displayalerts being set to
false won't supress runtime errors.

Mike

"Barb Reinhardt" wrote:

> I'm using Office 2003. I have this code
>
> Application.DisplayAlerts = False
> oWS.Copy after:=oWS
> Application.DisplayAlerts = True
>
> When I step through the first line, and hover over
> Application.DisplayAlerts, it still shows as TRUE. And when the copy
> occurs, I get a run time error. The sheet you are copying has more than 255
> characters, blah blah blah. I know it does. That's why I do other things
> later to capture all of the data. Why am I having DisplayAlerts problems
> here?
>
> Thanks,
> Barb Reinhardt
>

To demonstrate the phenomen try this small routine and hover over the first
line.

Application.DisplayAlerts = False
If Application.DisplayAlerts = True Then
MsgBox "enabled"
Else
MsgBox "Disabled"
End If
Stop
Application.DisplayAlerts = True
Stop

Mike

"Mike H" wrote:

> Hi,
>
> I can't comment on the runtime error but i'm not surprised hovering over the
> line shows displayalerts as TRUE it always does. Displayalerts being set to
> false won't supress runtime errors.
>
> Mike
>
> "Barb Reinhardt" wrote:
>
> > I'm using Office 2003. I have this code
> >
> > Application.DisplayAlerts = False
> > oWS.Copy after:=oWS
> > Application.DisplayAlerts = True
> >
> > When I step through the first line, and hover over
> > Application.DisplayAlerts, it still shows as TRUE. And when the copy
> > occurs, I get a run time error. The sheet you are copying has more than 255
> > characters, blah blah blah. I know it does. That's why I do other things
> > later to capture all of the data. Why am I having DisplayAlerts problems
> > here?
> >
> > Thanks,
> > Barb Reinhardt
> >

Mike,

I just ran the same piece of code again and no run time errors. All I did
was log off and log back on a while back. Can you explain that?

Thanks,
Barb



"Mike H" wrote:

> To demonstrate the phenomen try this small routine and hover over the first
> line.
>
> Application.DisplayAlerts = False
> If Application.DisplayAlerts = True Then
> MsgBox "enabled"
> Else
> MsgBox "Disabled"
> End If
> Stop
> Application.DisplayAlerts = True
> Stop
>
> Mike
>
> "Mike H" wrote:
>
> > Hi,
> >
> > I can't comment on the runtime error but i'm not surprised hovering over the
> > line shows displayalerts as TRUE it always does. Displayalerts being set to
> > false won't supress runtime errors.
> >
> > Mike
> >
> > "Barb Reinhardt" wrote:
> >
> > > I'm using Office 2003. I have this code
> > >
> > > Application.DisplayAlerts = False
> > > oWS.Copy after:=oWS
> > > Application.DisplayAlerts = True
> > >
> > > When I step through the first line, and hover over
> > > Application.DisplayAlerts, it still shows as TRUE. And when the copy
> > > occurs, I get a run time error. The sheet you are copying has more than 255
> > > characters, blah blah blah. I know it does. That's why I do other things
> > > later to capture all of the data. Why am I having DisplayAlerts problems
> > > here?
> > >
> > > Thanks,
> > > Barb Reinhardt
> > >