disable

For some unknown reason, whenever I paste a letter in cell e2 that is the same as the first letter in cell e9, it Autocompletes rather than just keeping the one letter "F". If I shut off Autocomplete it works fine. Similarly if I move "FLAME" to another column it also works fine. This happens...

Hi all, I have a program that inserts various square images onto the same size cells, on one particular sheet. From the code on a form, I want to disable all the images, to remove the grab points thus obviously preventing them from being moved, resized, etc. I also want to be able to click...

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 :)

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...

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!

Hello Can I have a macro to disable another macro Thanks Jason

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...

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)

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?

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.

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?

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...

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 =...

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

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...

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

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

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...

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

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