"...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"
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"
wrote in message
...
Dear All,
Since moving to office 2010 a macro somthimes (! 5 %) generates error 1004
on
this code
ActiveSheet.ResetAllPageBreaks
error text ( my translation from Dutch )
-2147417848 automatisation error
The connection of the called objects is broken
Filip