ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Personal.xls and Excel.xlb (https://www.excelbanter.com/excel-discussion-misc-queries/9866-personal-xls-excel-xlb.html)

Terry

Personal.xls and Excel.xlb
 
Hi.. I'm still trying and if you are still out there and
would give more help... it is needed.
I have a personal.xls that has all the macros I want in it.

Then I have a Excel10.xlb that I want to replace the
original Excel10.xlb with. However, then the menu items
no longer have the path to the personal.xls. It says that
cannot open personal.xls when personal.xls is already
open. If I close the hidden personal.xls it then cannot
find the path to personal.xls.

In toolbars custom view and selecting the menu item and
assign macro... nothing happens will not open to view
where macro is. Will not let me assign a macro?

Maybe it has just been a long day of trying and tomorrow
the answer will come.. meantime any other suggestions will
be appreciated.
Thanks...

Dave Peterson

I replied in the original thread.

Hope it works out.



Terry wrote:

Hi.. I'm still trying and if you are still out there and
would give more help... it is needed.
I have a personal.xls that has all the macros I want in it.

Then I have a Excel10.xlb that I want to replace the
original Excel10.xlb with. However, then the menu items
no longer have the path to the personal.xls. It says that
cannot open personal.xls when personal.xls is already
open. If I close the hidden personal.xls it then cannot
find the path to personal.xls.

In toolbars custom view and selecting the menu item and
assign macro... nothing happens will not open to view
where macro is. Will not let me assign a macro?

Maybe it has just been a long day of trying and tomorrow
the answer will come.. meantime any other suggestions will
be appreciated.
Thanks...


--

Dave Peterson


All times are GMT +1. The time now is 05:06 AM.

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