Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » Macros (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site
  • Make buttons in a protected workbook that call`s macros

    Hi everybody! I have a protected workbook that contains two macros that shows and hides certain columns. I want to add 2 buttons in my spreadsheet so that when pressed they will call the associated macro. The two macro`s are called Unhide_Columns_AR_AS and Hide_Columns_AR_AS Anybody out there which can...
    Posted to General (Forum) by Trond Michaelsen on Fri, Dec 7 2012
  • macro for defining range

    I have a large amount of data in a spreadsheet. I am tracking various data by part number. This workbook is sorted by Part number (column "A"). I am wanting to write a macro to find the largest number (in Column "G") for each group of duplicate part numbers. Once this number is found...
    Posted to General (Forum) by ajb999 on Thu, Sep 16 2010
  • Need to generate a packing list from an order form

    Every week managers from arounfd my company send me a supply order using teh attached spreadsheet. THe main page of the sheet is setup to atuomatically calculate their order total and then we fill the order. I would like to generate a packing list to include with their order. I need the packing list...
    Posted to General (Forum) by Asher on Wed, Apr 28 2010
  • Report Based on Single Column

    My understanding of Excel is pretty basic so 1. forgive me if this isn't the right section and 2. I'm not exactly sure how to ask this question. I am a teacher and I have a grade sheet that has several projects' grading rubrics in columns A and B. Student names are then arranged in columns...
    Posted to General (Forum) by magdelaine on Thu, Apr 1 2010
  • How to stop users moving a cell by accident

    Hi All I have a protected worksheet where all but a dozen cells are locked. The unlocked cells are in A1:A12. Occasionally, instead of entering data into A1:A12, the user will drag one of those cells onto another one unintentionally. Often they have no idea that they have moved a cell. Formulas in columns...
    Posted to General (Forum) by keghead on Sun, Nov 15 2009
  • Copying and Pasting with a Macro, multiple times.

    Hi there, I have a file with a decent amount of rows (thousands and thousands and thousands and...) In one of the columns, highlighted light red in the attached file, I have three rows of an address. I would like to create a macro that will go down the list and cut the second lines of the address and...
    Posted to General (Forum) by fraserk on Wed, Nov 11 2009
  • Combining Two Sets of Data

    Hi, I have put this in the general section as I don't know if I need VBA or if I can do this with a look up. Basically I have two sets of data; Set 1 eg. Promo Code Detail Creative Offer Expense Date Live XF2 PPC Promotion Jan 09 N/A 10% Off $2000 1/1/09 GGH Geographic Magazine Jun 09 Red 15% Off...
    Posted to General (Forum) by rebsbails on Wed, Oct 7 2009
  • ??? is there a way (function?) to store a number gained by calucalations into another cell where it is stored as a number free of calculations

    I use Excel in real estate and personal goal setting and run into questions that aren't evident to me.. like 'how to get around circular formula errors .. pair prior ttl today run ttl pair prior ttl total run ttl A/U 100 10 110 E/U 10 7 17 G/U 50 2 52 N/U 10 8 18 E/G 200 3 203 U/C 10 9 19 E/C...
    Posted to General (Forum) by caladdin on Mon, Jul 28 2008
  • Inter-sheet references (links) stop working

    I have a very unusual problem. My workbook is fairly substantial and uses a good amount of vba/vb to handle UI issues as well as perform some calculations via UDFs. Recently I have found a situation where inter-sheet links stop working. The application allows the user to add cashflow engines - it does...
    Posted to Misbehaving (Forum) by Charlie on Fri, May 2 2008
  • macro protection

    I want to secure macros from being edited, viewed or deleted by users. Does anyone know how to do this?
    Posted to General (Forum) by Tonysexcel on Wed, Apr 30 2008
Page 1 of 2 (14 items) 1 2 Next >
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.