macro button

  1. tlc53

    Lock edited cells with Macro Button

    Hi there, I have found instruction on how to lock cells immediately after data has been entered however, I'd like to lock the cells with a push of a button/macro. Is this possible? Data is currently entered in B12:K105. I would like it so when they hit the "Transfer Journal" button, any cells...
  2. tlc53

    Macro to hide and unhide multiple rows at a time

    Hi there, I have a table of 40 lines in which I manually hide/unhide depending on the amount of data needing to go in (40 lines max). I would like to have two macro buttons so that I can hide/unhide 5 rows at a time. So 1-5 would always show, add +5 line button and rows 1-10 would show, add +5...
  3. R

    Macro's not showing up in macro table

    I have a couple subs that call other subs that do not show up in the macro table. I guess because the sub simply contains arguments??? I would like to assign this to a button. Anyone know how I can get it to show up in the macro table? ****************************** Sub RunSolvers() If Not...
  4. B

    Calculate number of workdays since a date

    Hi experts - I'm looking for a macro to calculate the number of work days since a date (when a document was signed). Below is columns F and G from the workbook. <tbody> Document signed date Workdays since 01-January-2018 15-February-2018 </tbody> Now, I know that this can be fairly...
  5. J

    Popup message after clicking macro button

    Hello, I have the code below which I am using to send a spreadsheet by clicking a button. How would I go about having a popup message appear after clicking the button? What would the code look like for that? Thanks in advance. Sub SendWorkSheet() 'Update 20131209 Dim xFile As String Dim...
  6. J

    Macro to send worksheet to Outlook email

    Hi, I am not too familiar with macros. Is it possible to create a macro that will send a worksheet as an attachment to an Outlook email? I would like to create a "Submit" button at the bottom of my worksheet that will send the email if possible. Also, is it possible to have a dialogue box open...
  7. P

    Macro with Multiple If Statements

    Hello, I would like some help in creating a button macro for a spreadsheet that is essentially a user form. The form has four cells in which the user enters requested information in cells B6, B8, B10, or B12. Not all of the cells require a number. When the user clicks on the button, I would...
  8. D

    Multiple Macro Buttons Hide/Show Specific Amount of Lines

    Hi, I'm fairly new to vb all on my own and have a small understanding of it. I'm in voice engineering so I'm trying to map a sales workbook/form to a hidden tab for building the telephone lines in the switch via .csv, so learning excel was something I didn't expect. I have read many posts...
  9. J

    Cannot click macro button while in page break preview?

    Hello, I am trying to use a macro button that allows the user to set the page breaks. The goal would be to have the button work as listed below... If ActiveSheet is in PageBreakPreview mode, then switch back to normal mode If ActiveSheet is in Normal mode, then switch to PageBreakPreview As...
  10. M

    VBA- Auto-generate PO# and Auto-save as PO# for file name

    There is already a "Purchase Order" excel Template worksheet. There are 4-5 people using this document in one office, and they have a shared server where all purchase orders are stored inside a folder that is shared by everyone. Requirements: Whenever someone opens this Purchase Order document...
  11. R

    Click Twice on a Macro Button

    Is it possible to have a button on a worksheet do different things on its first click to a second click? For example, I currently have a button that unhides tabs in a worksheet and I would like the tabs to be hidden again if clicked twice, so like a toggle button? My code so far is as follows...
  12. J

    Create a macro button to show due dates "this week" or "this month"

    Hello, I am trying to create a macro button that shows due dates for "this week" and "the next two weeks" and "next month". I have delivery due dates in column K in a spreadsheet and at the click of a button, I would like to display only the rows that have due dates for this week, etc. Also...
  13. O

    VBA: create macro button to open file directory and import txt data to excel

    Hi all, ive been searching the web for answers over the weekend but to no avail. i have no knowledge on vba codes so go easy on me. i would need help on the following: 1. when i click the button, it opens file directory C:\desktop\ 2. i will proceed to select .txt or .csv file 3. upon...
  14. A

    Save Excel Workbook to user's desktop in text format

    Hi there, I've an Excel Workbook (SAP Upload File) that has an Export Button, on clicking it I want to ave a copy of that active worksheet to the user's desktop. After running the below code it is showing a compile error 'Expected End with'. If someone could check this out would be awesome...
  15. L

    Need Help with Macro Button to add 1 to cell based on dropdowns (Row/Column)

    I am having trouble with a macro button, that links to two drop-down boxes. My main sheet (YYD), has two drop-down boxes that reference my other sheet (Data). The first drop-down in YYD!F12 selects a row and the second drop-down in YYD!F17 selects the column on my 'Data' Sheet. I just need a...
  16. E

    Create Button That Prompts User To Select Active Cell

    Hello, I have a macro that uses the active cell to sort through data and fill the acceptable data into three new columns. I wanted to see if someone could help me create a button that prompts the user to select the active cell and then runs through my macro code. This would be very helpful in...
  17. O

    Purchase Order System - VBA for new worksheet from template with PO number auto generated

    I am part way through creating a Purchase Order system. I have so far: - One workbook - First worksheet 'Suppliers' is a list of suppliers with all supplier data - Second worksheet 'Template' is the PO template which uses Data Validate to choose supplier details from a drop down list. I want...
  18. C

    Ribbon and Quick Access Buttons not executing macros assigned to them

    Yesterday, I noticed that my custom "Close without Saving" button stopped working. I checked the VBA editor and my Personal workbook was missing and all of my personal macros were gone. I restarted excel, same issue. Rebooted my machine and they re-appeared. Not sure how what happened, but...
  19. M

    Emailing Workbook with macro button - HELP

    I have an excel workbook (2007) that has a macro that will clear the contents of a sheet. I have that macro assigned to a button on that sheet. I also assigned a keyboard shortcut to the macro. it works fine on my machine and when I email it to anyone inside my company. However, when I email...
  20. R

    Can a chart also be a macro button?

    Hi All, I'm using many small charts on a single worksheet to display information to the client. I would like to make this more interactive, ideally with the user being able to click on a chart and be taken to a worksheet containing more detailed data. I think that the question is then...

Some videos you may like

This Week's Hot Topics

Top