personal.xls...attention Robin????

P

paul

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)."
 
A

A.W.J. Ales

I don't know but it migth be caused by the way you created the file.
Did this happen by recording a macro or did you create it manually ?

Anyhow since it it IS maximised and visible : Make it the active workbook
and from the menu select Window / Hide.
It should then be hidden.

Close Excel and aswer the question about Personal.xls ( it is changed ;
should Excell save it ) with Yes.
At reopening it will be loaded but not visible.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top