force

  1. 3

    force at least one checkbox to be selected

    I have two groups of checkboxes (1-7 and 8-11). I am in need of vba code that will force the user to choose at least one checkbox in the group of 1-7. The checkboxes are in a merged cell range A9:K10. Additionally, if checkbox 7 is selected then L9:O10 must be filled in. Checkboxes were...
  2. I

    Force Enable Macros for user (Small issue)

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

    Forcing input by user when cells are changed

    Hi team, I have posted this same query at http://www.excelforum.com/excel-programming/780925-forcing-input-by-user-when-cells-are-changed.html#post2548789 a few days ago, but unfortunately there have been no replies. I am ultimately trying to achieve a track changes with commentary by the...
  4. 03856me

    Forcing Using of Button to Move Between Worksheets

    Excel 2007 - I currently have a sheet "Main" that contains many buttons for selecting reports, data entry userforms, etc. When the user selects one of these buttons the appropriate worksheet is unhidden and becomes the active worksheet. Each worksheet contains an "Exit" button with a macro to...
  5. T

    Forcing a Relative Reference

    Is it possible to force a relative reference for the following: =INDIRECT("a"&1) I understand that this is an odd thing to try to do. What I'm trying to accomplish is too complicated for me to attempt to explain. Here is one of the formulas that I'm trying to force to be a relative...
  6. N

    Force user to add copy of specific sheet instead of adding "New Sheet"

    I currently have a database set up with one sheet named "Master" the Master sheet has all of my ranges, labels, headers, and format set how I would like all sheets within the workbook to be set. I would like to make this workbook "foolproof" seeing as how some of the people who may be using it...
  7. K

    Require cell entries before macro button is visible

    Is it possible to force users to make a valid entry in three different cells before a button with an assigned macro is visible or clickable? For example, I want them to complete cells A5, B5 & C5. The first is a dept. code which can only be numeric (01 - 08). The second is the month (01 - 12)...
  8. M

    Force Users to answer survey questions

    I am putting together a simple feedback survey. I have a list of questions/statements that the user has to score from 1-5. (example: Rate the level of customer service you recieved). I have used option buttons to represent the numbers 1-5 and these are linked to cells in a hidden sheet and are...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top