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