disable

Hello, I want to disable drag and drop in my workbook. So I put this code in "ThisWorkbook" : Private Sub Workbook_Activate() Application.CellDragAndDrop = False End Sub Private Sub Workbook_Deactivate() Application.CellDragAndDrop = True End Sub It works, but when another vba code...

I have 20+buttons in a userform, how can I disable all buttons by a automatic sub? Only buttons

Hello Everyone i am new here and have a question i cant seem to find a answer to. Ok so i have a spreadsheet that tracks labor for a company i work for and they have provided bar codes to employees for there badge ids but they also have bar codes for activities that they choose not to use and...

Hi Guys, Can copy and cut be disabled in all but 1 work sheet? and leave the capability of pasting in the workbook? Thanks in advance for any feedback.

Hi Excelers, I have found numerous VBA codes that disables cut/copy and paste functions in an excel workbook, but what I need is the ability to paste and the disability to cut or copy. Additionally If I can deactivate the "prt scrn" functionality that would be a nice bonus. Thanks in...

Is there a way I can temporarily disable automatic protecting in the following code? Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Application.EnableEvents = False ActiveSheet.Unprotect Password:="WellingtonFrac" Set rng = Intersect(Target...

I have a workbook with a macro in a module file called by Ctrl+D but this fails with the error "Cannot run the macro. The macro may not be available or all macros may be disabled". In the developer tab I can see the macro but the "run" "step into" and "edit" options are all disabled. macro...

Hi all, I've found similar questions to this (disabling option buttons based on listbox etc.) but have tried all their code and tinkering about and can't get it to work. Apologies, I am quite new to this. I have a combo box, with 6 options. Depending on the selected option, a certain number...

Hey guys A friend of mine showed me, how to make sure, that no more cell or span can be added in a excel-sheet. He said, that in the last span/cell (65536) I have to put a space in, while the whole span/cell is marked. But I can still create new spans or cells. How do I have to do this, so it...

I have a query in which I'm converting number date "20150415" to "15-Apr-15" and then find the difference between 2 dates. first and last dates I'm using the following expressions; FLabour is a group by "Min" which is searching a Linked ODBC table. Fdate...

I have some code running on the click event of a shape. I want to enable/Disable on certain conditions. How to do it? Search results are not promising :( Thanks in advance. Possible? (atleast Hide or Show?) Edit: Shapes("ShapeName").visible hides/shows the shape. But How to disable/enable it?

is there a way to disable the save prompt when in an excel file? I have a share macro excel sheet and I don't want it to ask to save the file. When you manually close the file or Excel. Is this possible?

Hi there, I am trying to create a User Form using ComboBoxes and am struggling with a couple of things: 1) I have populated my ComboBoxes successfully (these cascade down 5 levels) but, if I select an option in ComboBox1, for example, the relating options in ComboBox2 do not appear until I...

How do I disable scrolling while my macro is running? I want my screen/window to be locked when the macro starts and unlocked when the macro ends. However, I do not want to disable ScreenUpdating. Application.ScreenUpdating = False Set x = ActiveCell ***macro*** x.Select...

Does anyone know how to get rid of the warning that comes with Macros? It is something to the effect of a warning of potential hazards of opening a document with Macros. A lot of the spreadsheets I work on I need to distribute and people get scared of opening or changing settings in excel when...

Hello All, I am trying to have lets say: if the cell A1 has "Solicitud" in it then the cel B1 should be enable for imput (I actually have the cel B1 validated with a Yes/No list) but if the cel A1 is blank or it does not have "Solicitud" then B1 cel should be disabled for editing. VBA code or...

Hi everyone, I was wondering if there is a way to select a range of cells and turn off their formulas. For example, =average(range1) =average(range2) might become '=average(range1) '=average(range2) without going into each cell and manually inputting ' Is there a way to do this...

Hello! I have a range of cells and if i select more than one cell in this range it will reduce my selection to one cell and everything works quite fine until i select for e.g. two cell but the cell right in the vicinity of my range of cells (and this column has a formula) in will select my one...

Hello Everyone, I have a validation drop menu (data / validation / settings / list) that I want to disable when one date is greater than another date. So for example today is 5th November but I want the drop menu to disable when the date is 6th November. Cell C1 contains a start date (can be any...

I have a form that opens up everytime the workbook is opened. In the code below it does a save as, when this happens I need the New Workbook to not have this form opening up . Im not sure if Im real clear on this but however I just don't need that form in the new workbook but I do need to keep...