Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ok here it's not a question about making a macro it's about binding it
on the toolbar or custom toolbar to prevent the bug i'm having. Here's the problem : I made a vba code in a module that take the selected image and give it a left/top/width position and add border to it, i work pretty well. The problem is when i add it to the toolbar here are my steps, Click on the kind of arrow and select add/remove button i select in the second tab macro, after i right click on the brand new macro icon and i go on affect new macro(i guess it's that in english my excel is in french well it's the bottom one) and after in the bottom in macro in : i select current document and i see my macro, i select it and click ok everywhere and bang it's there, i save it close reopen, and it work. now the problem appear when i make a copy of this file, the macro like i add it still pointing to the original if i delete the original file it say something like excelfile1.xls!mymacro cannot be found bla bla bla. Is there a way to keep the button binded to the current project macro. is there any vba function to rebind it eachtime, go for solution im a vb developper i can understand anything. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Email Macro Late Binding | Excel Programming | |||
Late Binding examples of binding excel application | Excel Programming | |||
late binding in excel | Excel Programming | |||
late binding in excel | Excel Programming | |||
EARLY binding or LATE binding ? | Excel Programming |