PC Review


Reply
Thread Tools Rate Thread

Assigning Macros

 
 
=?Utf-8?B?YmFycm93aGlsbA==?=
Guest
Posts: n/a
 
      26th Jul 2007
Having imported an earlier excel version workbook into v 2007 I have an addin
tab showing previously created buttons. These throw up errors when pressed
so I need to re-assign the macro's. It was quite simple in earlier excel
versions but I can't find how to do it in v2007.

Can anyone give me a step by step guide???
 
Reply With Quote
 
 
 
 
Jim Rech
Guest
Posts: n/a
 
      26th Jul 2007
I don't believe there is a way to do it through the Excel 2007 UI. Your
best bet may be to make the change in an earlier Excel.

This did seem to work though if you want to try to make the change by a
macro:

CommandBars("MyWindows").Controls("Redraw Toolbar").OnAction =
"RedoWinToolbar"

--
Jim
"barrowhill" <(E-Mail Removed)> wrote in message
news:90446896-149F-4366-AB75-(E-Mail Removed)...
| Having imported an earlier excel version workbook into v 2007 I have an
addin
| tab showing previously created buttons. These throw up errors when
pressed
| so I need to re-assign the macro's. It was quite simple in earlier excel
| versions but I can't find how to do it in v2007.
|
| Can anyone give me a step by step guide???


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assigning Macros =?Utf-8?B?UmFuZHk=?= Microsoft Excel Worksheet Functions 4 15th Nov 2007 08:56 PM
assigning macros =?Utf-8?B?ZW55YXc=?= Microsoft Excel Misc 1 6th Sep 2006 04:39 PM
assigning macros scott Microsoft Excel Programming 2 30th Dec 2003 01:59 AM
Assigning Macros T F Hewitt Microsoft Excel Programming 3 11th Oct 2003 06:57 PM
Assigning Macros Scott Microsoft Excel Worksheet Functions 1 5th Sep 2003 03:45 AM


Features
 

Advertising
 

Newsgroups
 


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