-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
disable macro button
-
Z
Disable and Enable a Macro button
Hey guys! Essentially what I want is for my macro button to run the macro ten times (through 10 clicks) and then disable. But I want the macro to enable again once I've run another macro in another sheet in the same workbook. Also, if say I run this macro only 2 times, and then I run the other...- zsb95
- Thread
- macro - help
- Replies: 2
- Forum: Excel Questions
-
S
Enable/Disable Macro Buttons within a macro
I have a spreadsheet that has two distinct areas. One area is open for editing and the other is not. I have added two macro buttons to the spreadsheet called "Unlock" and "Lock". When the "Unlock" Button is pressed, a macro opens the restricted area for editing. When the "Lock" Button is...- ssgmiami
- Thread
- Replies: 7
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Dynamic cell and sorting
- Started by Polanskiman
- Replies: 31
So here is the deal. I need that cell in E4 to be dynamic because the "Description" column on the Excel table is supposed to be sortable. By... -
How do I get combobox to get a cell number then link it to a selection from a checkbox in Excel?
- Started by Ayugma
- Replies: 31
I have no idea how to really implement this. So I have 5 checkboxes, all of which are parts to a machine. So, a user will be able to select as... -
VBA code works on works desktop but not on my own laptop
- Started by Monojono
- Replies: 30
Hello Readers and hopefully problem solvers, I have a large amount of coding across my workbook that works fine on my works desktop. However, on... -
Formulas referencing Pay Dates in year
- Started by rishijain11
- Replies: 27
Hi, I'm trying to build out this excel file to keep track of my finances. I could use some help with several formulas revolving around the pay... -
Sorting key
- Started by dpaton05
- Replies: 25
When you are sorting using range.sort method, one of the parameters is Key. If I want to sort by column A, with the header being in row 3 and the... -
Copy Range of Cells And Paste Until Last Row
- Started by Unexpc
- Replies: 21
Hi guys i have a page in range A41:H74 and i want copy this page and paste until last row of excel sheet. does any vba code to do this?