View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Filips Benoit[_2_] Filips Benoit[_2_] is offline
external usenet poster
 
Posts: 27
Default ResetAllPageBreaks

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


"Jim Cone" wrote in message
...
"...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