1. 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...
  2. 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!
  3. J

    Macro to disabe a macro

    Hello Can I have a macro to disable another macro Thanks Jason
  4. 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...
  5. 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)
  6. 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?
  7. 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.
  8. 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?
  9. 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...
  10. 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 =...
  11. 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
  12. 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...
  13. 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
  14. 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
  15. 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...
  16. 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
  17. 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
  18. 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...
  19. 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...
  20. W

    Disable SetFocus on ListBox

    Hi, I have a long ListBox and I have to scroll the UserForm to get to the bottom of the ListBox. Problem is that when I scroll down the focus is moved to scrollbar and when I click the bottom value on the ListBox the focus moves onto the ListBox and scrolls all the way up again. I would very...

Some videos you may like

This Week's Hot Topics