MichaelChau,

I turned on the macro recorder, changed the setting and this is what I got:

ActiveWindow.View = xlPageBreakPreview

hth,

Doug

"MichaelChau" wrote in message
...
Hi, i'm trying to automate excel functions. Can anybody tell me if there
is a
way to program the view setting "Page Break Preview".

Kind regards.