Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel Macro help


  • Please log in to reply

#1
AliWL

AliWL

    New Member

  • Member
  • Pip
  • 2 posts
I work on large spreadsheets that require empty rows to be removed. I found a macro that allows me to do this. For easy access I have loaded it on to my Quick Access toolbar (see the grey 'Piggy Bank' button in the picture below), however other members of my team could benefit with this macro as well. Wihtout having to copy and paste the same macro over and over again I would like to use the Add-Ins tab. We have other buttons in our Add-Ins tab so it would be useful to add this macro along with the others. I have gone through the normal stages (File > Options > Add-Ins > Go... > etc) but the button does not appear.

As you can see from the attachment below I have selected Removeemptyrows button to show, but it does not.Macro1.jpg

Any ideas as to why thi may be and how to solve this issue? I am new to macros so any help would be appreciated.

Many thanks!

PS - I use Excel 2010

Edited by AliWL, 05 March 2013 - 04:04 AM.

  • 0

Advertisements


#2
dm27

dm27

    Member

  • Member
  • PipPipPip
  • 272 posts
Hello AliWL,

Perhaps another user will have some tips regarding the Add-In, as I'm not familiar with the Add-In requirements. However I just wanted to share a couple other options.


1. You could customize the QAT for that workbook only and add your macro to a button there. The file will need to be saved as an .xlsm file type for that to function.
2. Assign the macro to a shape within the workbook and a user could click that shape to run the macro.

For either option above you would want to assign the macro to that workbook, so its available to other users.

All the best with your project.

DM
  • 0

#3
AliWL

AliWL

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
Hi DM,

Thank you for your response. I have already placed a button on the QAT and that works a treat.

Hopefully someone out there has knowledge on Add-Ins and can help.

Thanks again,

Ali
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP