button creation

  1. K

    Is it possible to use macros to bulk group and ungroup in password protected sheet?

    Hi everyone, I have a password protected spreadsheet that I can easily group and ungroup while it is protected. I am wanting to create a button to easily do a bulk group and ungroup while the sheet is protected. I am happy to have 2 buttons (1. Group, 2. Ungroup) instead of just 1. Is this...
  2. M

    Create button with update function for already present sheet

    Hello to all, so recently I am creating an excel sheet which creates a new sheet from data located in master(1st) sheet in the workbook. I have been following some steps in the below thread which helped me a lot in understanding various functions. Link with helpful base info A button("Master...
  3. C

    Buttons created with VBA are not fitting/aligning with the cell they should be on

    Hi. This was working perfectly until today, this morning it suddenly started to not work correctly. I'm not even sure if I changed anything, but I've gone back to an older backup I have and the macro looks the same, so maybe an Excel update ruined the macro? I've tried the macro on different...
  4. E

    Workout Randomizer

    Hi all, I am trying to make a randomizer in Excel to randomize my workouts. I currently have 4 workout lists in Excel: Abs, Arms, Chest, and Legs. The lists are made of strings with no numbers. What I want to do, is to have 3 different buttons, each for a different day (Arm, Chest, and Leg)...
  5. X

    How to work with an adjacent cell with an ActiveX button

    Hello guys, first time posting here (an first time posting in a forum ever). I'm desperate. I am programming an Excel File to act as a game interface (a very simple one, for a gamification project in my company). The thing is that I want to create an ActiveX button (why an ActiveX and not a...
  6. N

    Button to change formulas - Filter 3, 6 and 12 months next to This months orders column.

    Hi All, Probably the hardest thing I've had to do in excel and I need someone with a better skill set than I currently have please! I've put together a pretty big spreadsheet which draws data from ODBC links to a database. Part of the report shows how much has gone out over 12, 6, and 3...
  7. P

    Create Button from VBA

    I have a spreadsheet (A) that creates a new spreadsheet (B). I would like to incorporate some VBA code from Spreadsheet (A) that when Spreadsheet (B) is created, a button labeled "Show Data" would be created on Spreadsheet (B). Specifically speaking, I will have data in Column "E" that is...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top