Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
JHL JHL is offline
external usenet poster
 
Posts: 56
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Macro assigned to Toolbar problem

See:

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


--
Gary''s Student
gsnu200711

  #3   Report Post  
Posted to microsoft.public.excel.misc
JHL JHL is offline
external usenet poster
 
Posts: 56
Default Macro assigned to Toolbar problem

thanks

"Gary''s Student" wrote:

See:

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


--
Gary''s Student
gsnu200711

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro assigned to a button Sadcrab Excel Discussion (Misc queries) 12 December 8th 06 11:16 PM
Macro Assigned to a Button zephyr Excel Discussion (Misc queries) 1 October 25th 06 03:33 PM
Custom Toolbar Button No Longer Runs Assigned Macro Bryan Excel Discussion (Misc queries) 1 April 10th 06 06:02 PM
Why does macros assigned to a toolbar lose its link when saved as Elsa Excel Discussion (Misc queries) 3 October 18th 05 09:48 PM
Copying a workbook with custom toolbar assigned to a macro Matt W Excel Discussion (Misc queries) 1 February 4th 05 10:46 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"