Jeff

Also, make sure you have a cell (or range of cells) activated when you run
the "Zoom" code - if a chart is selected the code "ActiveWindow.Zoom = 50"
will fail.

--
XL2002
Regards

William



"jhartley " wrote in message
...
| Tom,
|
| Thanks I'll double check the focus.
|
| At least now I know what should work.
|
| Cheers,
|
| Jeff
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|