disable

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

    Macro to disabe a macro

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

    Folder Picker

    This works very nicely https://stackoverflow.com/questions/26392482/vba-excel-to-prompt-user-response-to-select-folder-and-return-the-path-as-string Does anyone know if there's any way to disable the Tools Button ?

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    • Replies: 44
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    • Replies: 35
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    • Replies: 28
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    • Replies: 24
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    • Replies: 23
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    • Replies: 23
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top