ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Personal macro workbook (https://www.excelbanter.com/excel-programming/421843-personal-macro-workbook.html)

[email protected]

Personal macro workbook
 
I have just installed excel 2007 and kepping excel 2003 also.

Now whenever I open Excel2003 or 2007, personal.xls opens and shows
visibali on my start bar.
Earlier it was not showing.

Can anybody help please?

Thanks.
Ketan

Dave Peterson

Personal macro workbook
 
Open xl2003
Make sure that personal.xls is active
window|hide
close excel and answer yes to the save prompt.

If you're using a separate personal.xls (personal.xlsm???) in xl2007, then
there's an option to hide the window somewhere on the ribbon.

wrote:

I have just installed excel 2007 and kepping excel 2003 also.

Now whenever I open Excel2003 or 2007, personal.xls opens and shows
visibali on my start bar.
Earlier it was not showing.

Can anybody help please?

Thanks.
Ketan


--

Dave Peterson

Ron de Bruin

Personal macro workbook
 
Hi Dave and Ketan

If you're using a separate personal.xls (personal.xlsm???) in xl2007

It is xlsb in 2007

What to do if your PERSONAL.XLS(B) is visible

When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it.

Excel 97-2003: WindowHide
Excel 2007 : On the View tab in the window group choose Hide

Then close Excel and say Yes to save the changes to your PERSONAL file.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
Open xl2003
Make sure that personal.xls is active
window|hide
close excel and answer yes to the save prompt.

If you're using a separate personal.xls (personal.xlsm???) in xl2007, then
there's an option to hide the window somewhere on the ribbon.

wrote:

I have just installed excel 2007 and kepping excel 2003 also.

Now whenever I open Excel2003 or 2007, personal.xls opens and shows
visibali on my start bar.
Earlier it was not showing.

Can anybody help please?

Thanks.
Ketan


--

Dave Peterson


Dave Peterson

Personal macro workbook
 
Thanks Ron.

Ron de Bruin wrote:

Hi Dave and Ketan

If you're using a separate personal.xls (personal.xlsm???) in xl2007

It is xlsb in 2007

What to do if your PERSONAL.XLS(B) is visible

When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it.

Excel 97-2003: WindowHide
Excel 2007 : On the View tab in the window group choose Hide

Then close Excel and say Yes to save the changes to your PERSONAL file.

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
Open xl2003
Make sure that personal.xls is active
window|hide
close excel and answer yes to the save prompt.

If you're using a separate personal.xls (personal.xlsm???) in xl2007, then
there's an option to hide the window somewhere on the ribbon.

wrote:

I have just installed excel 2007 and kepping excel 2003 also.

Now whenever I open Excel2003 or 2007, personal.xls opens and shows
visibali on my start bar.
Earlier it was not showing.

Can anybody help please?

Thanks.
Ketan


--

Dave Peterson


--

Dave Peterson

[email protected]

Personal macro workbook
 
On Dec 31, 10:28*pm, Dave Peterson wrote:
Thanks Ron.





Ron de Bruin wrote:

Hi Dave and Ketan


If you're using a separate personal.xls (personal.xlsm???) in xl2007

It is xlsb in 2007


What to do if your PERSONAL.XLS(B) is visible


When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it.


Excel 97-2003: WindowHide
Excel 2007 * * : On the View tab in the window group choose Hide


Then close Excel and say Yes to save the changes to your PERSONAL file.


--


Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in ...
Open xl2003
Make sure that personal.xls is active
window|hide
close excel and answer yes to the save prompt.


If you're using a separate personal.xls (personal.xlsm???) in xl2007, then
there's an option to hide the window somewhere on the ribbon.


wrote:


I have just installed excel 2007 and kepping excel 2003 also.


Now whenever I open Excel2003 or 2007, personal.xls opens and shows
visibali on my start bar.
Earlier it was not showing.


Can anybody help please?


Thanks.
Ketan


--


Dave Peterson


--

Dave Peterson- Hide quoted text -

- Show quoted text -


Hi,
Thanks to both of you.
Ketan


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com