#1   Report Post  
jtimb
 
Posts: n/a
Default Macro won't run

I have several macros assigned to buttons on a worksheet, and when I sent
this worksheet to a colleague, he could not run the macros. It gave an error
of "could not find," and went into a debug mode.

When I saved the document to a share drive he could not run them still when
opening off the share drive. Other people are able to run them and I
obviously can, but this one person can't. I went to his computer and
verified that he couldn't. His security is set to medium so he is given the
option to enable macros. Still nothing.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

If you go back to the pc that has the troubles, try rightclicking on one of the
broken buttons.

Click on the Assign Macro option and see where it points to.

It sounds like you have to reassign them to the current workbook.

What kind of buttons are they and how did you copy that workbook? I can't
remember having this kind of trouble with buttons from the Forms toolbar and
copying via windows explorer.

jtimb wrote:

I have several macros assigned to buttons on a worksheet, and when I sent
this worksheet to a colleague, he could not run the macros. It gave an error
of "could not find," and went into a debug mode.

When I saved the document to a share drive he could not run them still when
opening off the share drive. Other people are able to run them and I
obviously can, but this one person can't. I went to his computer and
verified that he couldn't. His security is set to medium so he is given the
option to enable macros. Still nothing.


--

Dave Peterson
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 and sub rountines The Good Deeds Team Excel Discussion (Misc queries) 1 March 23rd 05 11:26 PM
Playing a macro from another workbook Jim Excel Discussion (Misc queries) 1 February 23rd 05 10:12 PM
Date macro Hiking Excel Discussion (Misc queries) 9 February 3rd 05 12:40 AM
Macro and If Statement SATB Excel Discussion (Misc queries) 2 December 3rd 04 04:46 PM
Macro Formula revision? Mark Excel Worksheet Functions 1 November 28th 04 01:43 AM


All times are GMT +1. The time now is 04:16 AM.

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

About Us

"It's about Microsoft Excel"