automatically run code

  1. R

    Copying a button from one sheet to automatically run code when copied to new sheet.

    Hi I am struggling with getting a macro to run when I create a new button on a sheet. I assign the On Action to the button and the macro runs without debug, but... the OnAction doesn't run the Macro "Test". The Button being copied to Sheet2 is on Sheet1, then the Macro should automatically run...
  2. T

    VBA Macro to auto run on open and close with formatting

    Hi, I am trying to keep column G as text format. I would not like anyone to change the format as another program needs to read it as text. so the format has to be for ex. 12/22/2014 or 12/01/2014 but text and users should not be allowed to change it. What i had so far is not working, can...
  3. craig.penny

    Run a macro after the security setting is lowered

    Hi all, I have a macro with a lot of hotkeys that are set in the "WorkBook_Open" event code but many people get it and need to turn thier security settings down so they can run any macros. That is, none of the hotkeys will be set since that event code didn't run. Is there any method to...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    • Started by ipbr21054
    • Replies: 37
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    • Started by Moeey
    • Replies: 34
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    • Started by zookeepertx
    • Replies: 30
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    • Started by AllisterB
    • Replies: 30
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    • Started by bricegoing
    • Replies: 29
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    • Started by laura_pink
    • Replies: 27
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top