LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Custom button to call a macro in Personal

The problem:
------------

So I have Excel 2000 still. Some day I will upgrade. Windows XP SP2.

I have three custom buttons on my custom toolbar. They are supposed to
call three macros in Personal.xls. Well, each button should call one
macro, but you know what I mean.

When I click on any of the custom buttons, I get the message:

"A document with the name PERSONAL.XLS is already open. You cannot open
two documents with the same name". And so on.

I *know* this, I don't want Excel to try to open Personal.Xls AGAIN,
it's ALREADY open, you silly program, just use the macro out of the
ALREADY OPEN copy of Personal.xls.

If I start Excel and I'm looking at the empty Book1, I can go to
Tools/Macros/Macro and run any of my three macros. All the macros do is
some simple formatting.

What I have done:
-----------------

I right-click on the toolbar, choose Customize, then right-click on any
of the buttons, and select Assign Macro. What I see in the Macro Name
box is

'C:\Documents and Settings\David Walker\Application Data\Microsoft\Excel
\XLSTART\PERSONAL.XLS'!Module1.FNumber2

Now, this is strange, because there's not a folder in Documents and
Settings CALLED "David Walker", but there IS one called "David.DAVID-C".

I have tried assigning the button to:

'C:\Documents and Settings\David.DAVID-C\Application Data\Microsoft
\Excel\XLSTART\PERSONAL.XLS'!Module1.FNumber2

but when I look again, it's set to

'C:\Documents and Settings\David Walker\Application Data\Microsoft\Excel
\XLSTART\PERSONAL.XLS'!Module1.FNumber2

I don't know where Excel gets off thinking my local stuff is in David
Walker instead of in David.DAVID-C.

When I'm looking at the Assign Macro window, the three macros are listed
below as PERSONAL.XLS!Fdate and so on. I have tried assigning the
custom button to just PERSONAL.XLS!FDate, by picking it from the box,
but that still gives me the message that Excel can't open another macro
with the same name.

Plea for help:
--------------

Does anyone have any suggestions how to get out of this mess? I have
searched Google and there are only a few hits on that error message,
none of which are very helpful.

I have the same buttons working just fine in my setup at work, but they
don't work in my setup at home.

Thanks!

David Walker
 
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
2003 - 2007 custom macro and custom button restore. Scott Sornberger Excel Discussion (Misc queries) 11 May 23rd 08 02:41 PM
How can I call IE browser (Back button) through Excel macro? SAM SEBAIHI Excel Discussion (Misc queries) 0 December 13th 06 04:50 AM
Custom button on custom toolbar wants to re-load "Personal.xls" Aussie Dave Excel Programming 1 March 25th 05 10:19 AM
Call Userfor and click button with macro ExcelMonkey[_190_] Excel Programming 2 February 25th 05 04:41 PM
Button won't call macro Lift Off Excel Programming 6 April 13th 04 10:44 PM


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

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"