execute an Add In

Hi Guys.

I have tried to create an add in >

Open Workbook > Developer > Visual Basic >

Sub move()
Columns("A:Z").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlToLeft
End Sub

Save as addin in Addins folder

I located in and ticked it in addins available

I then opened the book which I wanted to run it on and zip, zero nada! do i need some sort of execute code?

Thanks alot for looking

Hey tiger - thanks thats great ! you have really saved me a ball ache after an hour of googling!! thanks bud

Hi - there folks.

I went to the addin folder and inserted

Please Login or Register  to view this content.

in This Workbook

Saved and closed, but the only way i can get it to work is by Developer tab > Visual Basic > hitting the execute button.

I was under the impression that i could run an add in from the add in box by checking it and pressin ok???

Anyone know what i'm doing wrong???

cheers

Hi,

I was under the impression that i could run an add in from the add in box by checking it and pressin ok???

xla and xlam are effectively workbooks with all of the sheets hidden (as Tiger mentioned). When you tick it in the add-in box and click OK, it installs the add-in. For xla and xlam, "installing the add-in" basically means that the add-in workbook is opened in the Excel instance: the only code that would run in the add-in at this stage would be like these:

• Workbook_Open()
• Workbook_AddinInstall()
• Auto_Open()

Once the add-in is opened, it means that the code within it, such as your Move procedure, will be available for use. A lot of people design an interface - such as a commandbar with buttons on - which is created when the add-in is opened, so that people can easily run the bit of code they want.

Hi Colin - thanks alot for that.

I now understand that I need to create this cmd button for my colleagues so as that they can run the macro.

Will start googling "command bar for add-in's!! looks like i'll miss dinner tonight!!

Cheers Colin for the detailed explanation!

EDit: I couldn't wait! my wife has given me permission to stay up!!

Hey tiger (can't believe that i'm calling a bloke "tiger"!) - thanks v much for your comprehensive response. it's 21:35 here so will try your approach tomorrow morning and let you know how I get on! am looking forward to it!

cheers dude

Hi --

My ThisWorkbook now looks like this.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

So now i need to find out how to create a cmd button and where to put it!!! cheers!

Hi Guys - update time!

I applied the following code to a workbook and saved as an add-in. I then checked it on the addins available bit and got the new addins tab on my ribbon with the my macro button name.
The problem occurs when i hit the button - i get the msg cannot run the macro moveXLAMMy Macro The Macro may not be available in this workbook or Macros may be disabled.

I have them enabled so it must be the first one!

Can anyone suggest a way out or what i have done wrong. Its the first time I have tried this so the water is a little (alot) murky!

Cheers

Please Login or Register  to view this content.

Hi Guys - am having great difficulty here in spite of the kind help i have already recieved from Tiger and Colin yet I am still not able to achieve my desired result which is:

To run this code

Please Login or Register  to view this content.

Via a command button on the ribbon.

I need to set this up for collegues.

Please Login or Register  to view this content.

But am getting an error message "The Macro may not be available in this workbook or Macros may be disabled"

Any help appreciated as am struggling here. Cheers

I feel like a right dufus - i'm new to this stuff but intend to learn pronto!!! cheers tiger man will check this out now!

Hiya - can you please have a look at the attachment -

I keep getting the error msg " cannot run the macro move xlam move. the macro may not be available in theis workbook or all macros may be disabled. "

macros are not disabled.

So sorry to bother you. but would love to get this sorted and learn from it!!!

Thank you very very much! dude........ you have no idea how much googling I did today to try and resolve this issue!

Thanks for your patience.

I can see from your file what I did wrong. i put all code in ThisWorkbook whereby from the looks of it i should have put the macro code in a module!!

However, going through this has inspired me to get booked on a vba course.

Thanks v much.