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 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...
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)
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.
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.
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...
I have an excel file with 3 checkboxes that enable and disable conditional formatting (to find duplicates) using something like this:
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?
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...
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.
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...
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
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...
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...