restriction

  1. J

    Grant file access to macro but not to user profile?

    Good afternoon A bit of a strange one on a process I'm currently changing. Currently, the business emails payroll data to the payroll team in a variety of weird and wonderful formats for them to manually process. I've streamlined the process by standardising the submission using VBA and...
  2. R

    Cell restriction

    Hi good after noon, I am using an excel chart and finding solution to restrict cells in a row for writing, if a particular word will write in a CRITERIA cell the restriction will remove to allow for writing. <tbody> A B C D 1 DESCRIPTION VR / KYC AMOUNT 2 Transfer (ALLOW TO WRITE)...
  3. B

    VBA compact attributes in less columns

    Hi everyone. My first post here but used as inspiration many times. The original data is on A1:F14 and the desired outcome in K1:M14. I`m looking to use less columns to show attributes for each ID on column A. The single restriction is that the unique strings must be placed on the same column...
  4. Y

    Data Validation Restriction.

    I'm using Excel custom data validation to restrict entry in A2, if A1 is 0 or blank. The formula =A1>0 works just fine if A1 is a number greater than 0, but if A1 is blank, the restriction does not work. Put another way, I want a blank cell In A1 to be treated as if it was a zero. I've tried...
  5. B

    Restricting use of one cell based on another

    If a user fills out one cell, I want to restrict them from filling out another cell within a certain range. And if they try to do so, I want them to be prompted with a message box explaining the restriction. eg. <TABLE style="WIDTH: 155pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0...
  6. N

    Excel 2003, Validation across range

    Hi all, Could somebody guide me on this please? How would I ensure that only one cell across a range could be filled? E.g. across five horizontal cells, say A1:E1, I want to restrict that only one of those cells may be filled. I.e. if A1 is filled (with text or numbers), then B1, C1, D1, and...
  7. J

    Character Restriction Limit on VBA

    Hi. I am using VBA on Microsoft Excel, and have created a userform containing several text boxes. On one of these text boxes, I am trying to implement a character limit, restricting users from entering more characters than a specified limit (In my case, the limit needs to be 8 characters). I've...
  8. J

    VBA Help

    I am currently creating a userform on microsoft excel using VBA. This userform is for a car company. I have a text box for the mileage of the car, this text box is named txtmileage. I am trying to figure out how to create a character restriction, making it so only numbers are valid inside the...

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