enable

Is there a way to lock it from editing but enable selecting the text for copy operation? Thx for help Piotr

I have found some code to open each workbook in a folder and copy range X:X. The code works great, but for the approximately 8 workbooks the code is grabbing the data from, I have to click Enable Content 8 times. Since I can't alter any of the settings in the Trust Center, is it possible for a...

Hi there, I am new to VBA and just used YouTube to create a calculator for work. My colleagues and seniors (who have seen it) love what Excel can do as it will save so much time. In order for the company to want to proceed it requires testing, however I cannot do this due to the following...

Hello Is it possible to enable the display of the formula box directly from the toolbar like it use to be? At the moment, I do advance setup to enable it and need to redo it after each reopening Martin

The following code was tested in Excel 2013, with the macro settings at option 4, ie Enable all macros (not recommended; potentially dangerous code can run). Option Explicit Private Sub Workbook_Open() Application.OnKey Key:="^n", Procedure:=vbNullString End Sub...

I have 2 files 1.xlsm and 2.xlsm. Both have instruction messages when they are opened. when 1.xlsm opens 2.xlsm it is only using it for the data in the spreadsheet cells and doesn't need the open message or enable any macros. Is there a way to bypass the open message, the "the workbook contains...

Hi All, I'm trying to create a file for others to click a button to enable the file to become a shared file. Is there a code that I can use that could enable me to do this?? Many thanks in advance! R/ Pin :confused:

Hi Guys, I have a cell on sheet 1 which updates every second with the current time. the format of this cell is hh:mm:ss. I then have a sheet with cells for different premises again with the format hh:mm:ss. I have a command button for each premises on a page. However, i dont want anyone to be...

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?

Hi guys I need a information if we can enable a line in excel. I want to enable some cells, to nobody edit it. Thanks

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

Please find attached the spreadsheet. Do not use Scoring spreadsheet. Please use Marks Spreadsheet. I have a 200 row spreadsheet where C2 to C200, all rows have combo boxes. The possible selections within the combo box are "Yes" or "No". I want a combo box to be enabled in D2 to D200, only if...

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

I have a program that I have been developing. I save a new version from time to time when I make substantial enough modifications. Some versions of the saved program start the macros bringing up the userform after enabling only the first time in a new version. Other saved versions require that...

Hey everyone, I am a new user on Excel and I have been using tutorial succesfully so far, however im stuck with a problem. I needed drop box for a project so I used activex dropbox and needed the value of the drop box in a cell so i used range ("A1") = me.combobox1.value. Everything worked so...

Hey I have found some code on VBA Express which I really like. It is the smoothest running code to perform is task that I have come across, however I have a small problem that is annyoning me. For orignal post: http://www.vbaexpress.com/kb/getarticle.php?kb_id=578 If I close the the...

I have been trying to use a checkbox to activate or deactivate a process, it has however not worked for me...I've recently started using macros and would really appreciate help...thanks in advance! This is what I wrote: Sub CheckBox94_Click() If CheckBox94.value = True Then 'run enable macro...

Hi, I use the following code to open a number of specific workbooks in excel automatically on booting a computer. However, the add-ins in these workbooks are disabled when they open. I have code to auto install the necessary add-ins, which works fine normally, but doesn't work on the sheets...

I am working in Excel 2007 When I open my spreadsheet, I see the macro security banner and have the option of clicking on it and then enabling macros. However, sometimes I forget and start working on the spreadsheet and notice that the macro security banner has disappeared. Is there a way to...

Is there a Macro that ensures that macros are always enabled, everytime the workbook is opened? I am looking for something that I can apply to my workbooks that ensures that the macros I have written for my passwords are always enabled.