ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro assigned to Toolbar problem (https://www.excelbanter.com/excel-discussion-misc-queries/135955-macro-assigned-toolbar-problem.html)

JHL

Macro assigned to Toolbar problem
 
Using Excel 2000, I have created a custom toolbar icon to print the filename
and path in my files from a macro I have created and saved in the
Personal.xls spreadsheet. However, I receive this message when I try to use
the macro pressing the toolbar button:

€œA document with the name €˜PERSONAL.XLS is already open. You cannot open
two documents with the same name, even if the documents are in different
folders.
To open the second document, either close the document thats currently
open, or rename one of the documents€.

I can run the macro going thru the menu selection process.

I seem to have this issue since switching to Excel 2000. I did not
encounter this using 97.


Gary''s Student

Macro assigned to Toolbar problem
 
See:

http://groups.google.com/group/micro...0d984d0030eac0


--
Gary''s Student
gsnu200711


JHL

Macro assigned to Toolbar problem
 
thanks

"Gary''s Student" wrote:

See:

http://groups.google.com/group/micro...0d984d0030eac0


--
Gary''s Student
gsnu200711



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

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