ResetAllPageBreaks

  • Thread starter Thread starter Filips Benoit
  • Start date Start date
F

Filips Benoit

Dear All,

Since moving to office 2010 a macro somthimes(! 5 %) generates error 1004 on
this code

errortext ( my translation from Dutch )
-2147417848 automatisationerror The connection of the called objects is
broken

Filip
 
I don't have an explanation/reason for you.
An alternative you can try is...

Cells.PageBreak = xlNone

--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/ExtrasForXL
(free trial - commercial add-in)

..
..
..

"Filips Benoit" <[email protected]>
wrote in message
Dear All,

Since moving to office 2010 a macro somthimes (! 5 %) generates error 1004 on
this code

error text ( my translation from Dutch )
-2147417848 automatisation error
The connection of the called objects is broken
Filip
 
Jim,

No succes, but now I set the view to xlNormalView before
'ActiveSheet.ResetAllPageBreaks' and it seems to work.

Origionally the sheet in in Pagebreakview having row 1 Frozen.
Can this be the reason to trigger error on 'ActiveSheet.ResetAllPageBreaks'
?

Filip


"Jim Cone" wrote in message
I don't have an explanation/reason for you.
An alternative you can try is...

Cells.PageBreak = xlNone

--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/ExtrasForXL
(free trial - commercial add-in)

..
..
..

"Filips Benoit" <[email protected]>
wrote in message
Dear All,

Since moving to office 2010 a macro somthimes (! 5 %) generates error 1004
on
this code

error text ( my translation from Dutch )
-2147417848 automatisation error
The connection of the called objects is broken
Filip
 
re: "...Row 1 Frozen. Can this be the reason to trigger error..."

It shouldn't be, but it becomes a matter of what works vs. what doesn't work.
'--
Jim Cone


"Filips Benoit" <[email protected]>
wrote in message
Jim,

No succes, but now I set the view to xlNormalView before
'ActiveSheet.ResetAllPageBreaks' and it seems to work.

Origionally the sheet in in Pagebreakview having row 1 Frozen.
Can this be the reason to trigger error on 'ActiveSheet.ResetAllPageBreaks'
?

Filip


"Jim Cone" wrote in message
I don't have an explanation/reason for you.
An alternative you can try is...

Cells.PageBreak = xlNone

--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/ExtrasForXL
(free trial - commercial add-in)

..
..
..

"Filips Benoit" <[email protected]>
wrote in message
Dear All,

Since moving to office 2010 a macro somthimes (! 5 %) generates error 1004
on
this code

error text ( my translation from Dutch )
-2147417848 automatisation error
The connection of the called objects is broken
Filip
 
Jim,

Since starting from sheet in xlNormalView no error in about 30 test, so
I think (hoop) maybe finally after 30 days the problem is solved!

Filip
 
Back
Top