![]() |
personal.xls...attention Robin????
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)." |
personal.xls...attention Robin????
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 * "paul" wrote in message ... 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)." |
All times are GMT +1. The time now is 10:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com