disable

  1. D

    VBA - disable insert partial rows

    Is it possible in VBA to disable inserting partial rows to let the user only insert full rows. Protecting the worksheet is no option because of all the macro's behind the worksheet. Thanks in advance :)
  2. Fida_mutia

    Disable and enable one of excel functions in ribbon menu.

    Hey, I wanna know how to disable one of excel functions in the ribbon menu? And how to enable it again? For example, I want to disable the pivot table function so that I can't create pivot table in my worksheet. Also I want to know how to enable the pivot table function again. That's all my...
  3. T

    disable design view in Access

    I am trying to disable the design view so user cannot make any changes. Greatly appreciate if you can help or what other option I can do to protect my database from being modified. Thank you!
  4. J

    Macro to disabe a macro

    Hello Can I have a macro to disable another macro Thanks Jason
  5. P

    Lock listbox after CLICK event

    I have a listbox with code that runs after user makes a selection (clicks item). It's a Form Control (vs. ActiveX type). Right now, while the code runs (takes about 5 seconds to complete), user can immediately click another item on list and listbox selection changes (though click event doesn't...
  6. B

    block user from refreshing pivit tabel

    hi is there a way through an excel vba to disable the refresh button in excel for a power pivot table or any type of refresh ? i don't want to protect the sheet i just want to disable refreshing it (with a password)
  7. B

    Disable / enable doubleclick on userform

    Hey all, I got a few labels on my userform that are editable by users once they login. At the moment they can always change the labels. I would like to disable this until they are logged in. Someone knows what code i need to enable / disable the double click event on a userform?
  8. B

    Disable read-only warning in yellow alert

    Is it a new thing all of a sudden that Excel is warning me that my file is read-only in the yellow security message towards the top of the sheet? Can I disable that somehow? To be clear, I want to keep the document as read-only, but I don't want to get warned about it every time I open it.
  9. D

    disable check box based on other checkbox

    Access 365 Within my main form f_pac, I have 3 check boxes (USA, Canada, Combined) I need to have them enabled/disabled. If either USA or Canada is checked then disable Combined. and if Combined is checked disable USA and Canada. How can I do this?
  10. H

    Disable Save and Save As

    I want to disable both Save and Save As - I have VBA that saves the document specifically for the user and I don't want them to try and save it as their own file. I have this: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI = True Then...
  11. T

    VBA Adding and removing conditional formatting

    Hello all, I have an excel file with 3 checkboxes that enable and disable conditional formatting (to find duplicates) using something like this: Sub ChkBxA() Dim rg As Range Set rg = Range("F6:H59,J6:CK47,CW6:CW1000") Dim Chk As CheckBox Set Chk =...
  12. E

    VBA Editor not autocompleting

    Why is my VBA Excel editor not autocompleting while I type the code? For example: if I type "Selection". I'll usually expect to see the list of things I can do with it. Maybe I disabled any setting? Thanks
  13. C

    Disable button after first use/enable again after re-opening file

    Hi everyone, I created a command button from the ActiveX controls. I want it to add +1 to a certain cell, update the date in another cell, disable after clicking it once and re-enable after closing and opening the excel file. I got everything working but the re-enabling... please help, this is...
  14. S

    Automatic Disable vba code after specific timeframe

    Hi, I need a automatic vba code to disable the existing vba file after specific timeframe and specific date. Thanks
  15. S

    Disable copy and enable cut

    I have a list of running numbers. every time i need to cut few numbers and paste at another workbook. the reason for cut is to prevent copy same running number twice or more. so, i need to disable copy while enabling cut and paste to another workbook. Thanks Shan
  16. M

    Disable Refresh in Power Query workbook to create backup?

    Hello and thank you in advance if you can help, I have put together a Power Query workbook with Pivot tables. All my data is through links, so I will, hopefully, then be able to have everything refresh to provide the new output as I get new data on a monthly basis. I would like to know if I...
  17. D

    VBA to disable Cells

    Hello, Please help me, i need to disable editing of cells, sample range A2:A5000 value "TRUE", i need to disable the range F2:F2000 to J2:2000. and mandatory to input for B2:B2000-E2:E2000. Thanks in advance
  18. A

    Disable Enter key in specific excel file

    Hello to all! Hope you can help me. I have an issue in an excel file that i want to disable 'enter' so users can navigate in excel sheets with arrows only. is there a simple way to de-activate the enter key only for the specific excel file (lets call it test.xlsx thanks!! Andreas
  19. M

    Disable a Control Button

    I am Using a Forms Control button to run a macro. I would like to have the Button disabled till certain requirements are met. How can I disable the button. It is called Button 6 I have tried the following code but the button still works as normal even though the sheet is protected...
  20. C

    Disable MsgBox permanently after "OK"

    OK excel guru's, I have a MsgBox that runs when I open the workbook template telling the user to paste previous days data in the prev day worksheet before proceeding. What I want is to permanently disable this MsgBox after selecting OK so once the user has saved the file under the new name it...

Watch MrExcel Video

This Week's Hot Topics

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
Top