If i have the macro in a file called personal.xls saved in
the folder described below,excel starts with personal
maximised in the window.Could it be related to our
network /profiles????

"If you put the macro in a file called personal.xls and
save it in your
xlstart folder (C:\Program Files\Microsoft Office\Office10
\XLStart) then

1. personal.xls will open as a hidden file each time you
start excel
2. the macro will be generally available and the windows
won't change.

Alternatively, you could save the file containing the
macro as an add-in
(which never shows a window)."