disable

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

Dear All, I am creating a survey in Excel 2010, where I need to disable the second group of option buttons based on response given/clicked in first group of option buttons. What I want: If the user selects 'NA' radio/option button, assign its value as '0', and disable all corresponding...

Dear All, I am creating a survey where I need to disable the second group of option buttons based on response in first group. If user selects 'NA' radio button, all options in second group should be disabled. My worksheet looks like this ..(attached worksheet)...

Hi, I have some embedded chart objects that I would like to protect from user selection and moving/editing, without necessarily protecting the sheet itself. Is there a simple VBA code instruction to toggle on/off the selection of all chart objects (or individual chart objects) within a...

Hi I have two combo boxes. What I need is if a selection is made in the first combo box, I want the second combo box to be disabled and vvice versa. Is this possible?

Hi Everyone, I am trying to create a macro to enhance the idea behind "For Internal Use Only." I have a button that will do the following I would like it to disable Reply, Reply to All, Forward I would like to disable the ability to Copy and Paste (or modify the message body). I would also...

<TABLE style="BORDER-BOTTOM: rgb(228,237,246) 1px solid; BORDER-LEFT: rgb(228,237,246) 1px solid; WIDTH: 98%; BORDER-TOP: rgb(228,237,246) 1px solid; BORDER-RIGHT: rgb(228,237,246) 1px solid" cellSpacing=0 align=center><TBODY><TR><TD> </TD></TR><TR><TD></TD></TR><TR><TD...

I have an issue that I constantly get the "macros have been disabled" popup when trying to run my macros and it isn't even constant in the fact that it only stops running macros on one workbook and continues to allow them on others workbooks sometimes. The trust center is still set to allow...

Hello all. First off I want to thank the forum--for almost a year now this has been a place I've found a ton of help as a new user. I appreciate all of the work that goes into helping anyone and everyone (beginner, advanced and otherwise). Question I've included an example. my spreadsheet is...

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 have a spreadsheet with many different tabs, i want to make it so that the user is unable to select multiple tabs at one time. I tried using the below code in the indiviual sheets code Private Sub Worksheet_Change(ByVal Target As Range) if activewindow.selectedsheets.count > 1 then...

I have a text box txtYesNo that is populated very simply via VBA code once the field appt_dte is updated: Private Sub Appt_Dte_AfterUpdate() If Me.appt_dte > Me.ConfCollDte Then Me.txtYesNo = "yes" Else Me.txtYesNo = "no" End If End Sub If the text box becomes "yes," I...

I have an Excel 2007 macro-enabled template to open all workbooks in a given directory, copy all the sheets back into the template file, then perform some analysis. The issue I'm coming across is that when the code cycles through all the workbooks in my directory, on occasion it will come...

Hi, Thanks for all the help so far! I've now completed my model, but have encountered the following security issue when I try to protect my sheet: I have added the following code to enable grouping/ungrouping on my protected sheet, but the VBA interface and code can still be opened (and even...

Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have a very challenged audience who can't work Marco security.<o:p></o:p> <o:p></o:p> This is causing problems as I have hide/show filters, counts and other macros running on the WB...

Afternoon, I disabled the the x button for closing down the spreadhseet using: Public Sub Workbook_BeforeClose(Cancel As Boolean) Cancel = True End Sub Unfortunately when it try and save using my save&close button it will save but wont allow it to close. ive tried button an IF...

Is there a way i can disable a macro if a cell isn't filled in? So that the button just won't press if there's no information in a specific cell?

Thought this might help some people. I was looking for a way to eliminate the 2007 ribbon using VBA. Unfortunately, you have to use UI editor (http://openxmldeveloper.org/articles/customuieditor.aspx) as well as some VBA. To do so, type the following vba into a module Option Explicit...

I have a sheet with a number of checkboxes, and I need to conditionally enable/disable some of them. For example, if the user checks Box1, then the question for Box2 becomes relevant and Box2 becomes available. If Box1 is unchecked, Box2 needs to be unchecked and disabled. Is this possible and...

Hi, So here's the story: I have 24 workbooks, with 12 sheets in each workbook. I have a macro written for EACH sheet in EACH workbook. I also have code written in the first module of EACH workbook. These 24 workbooks are in a folder. I then have another workbook called "Export" which is not...