restrictions

  1. S

    Add a Row dynamically anywhere in a table besides the first row

    I want the ability to add a row anywhere in a table besides the first row (row 18) . The code I have to dynamical add a row is below. I already built in restrictions that only allow the user to add a row into a designated table. I just don't want them to add a new row to the absolute first row...
  2. H

    Formatting requirements/restrictions for data entered into cells (formatting masks)

    Hello, I would like to restrict/require certain data in cells entered into to different columns as follows: In column B the format needs to look like the following example: N1234 with the first character being an alpha value and the next four need to be numeric values In column C the format...
  3. S

    Multiple Data Validation and Restrictions

    I have an excel sheet that I am attempting to apply restrictions to and also requires a drop down list. End Goal: I want to make it to where a user has to select a cell in COLUMN A, choose a value from a drop down list (drawn from COLUMN D), before inputting any data in the corresponding cell...
  4. G

    Enabling Read/Write Permissions

    I have vba code that performs a Save As, creating and naming new files. The new files should not have any read/write restrictions. They should be available for anyone to open, read and make changes. What should the code say to remove read/write restrictions on the new files? Thank you
  5. P

    Input restrictions in input box

    How do you make sure error checks appear when an invalid number is inputted for calculations? E.g Numbers that does not end in .23 is entered, an error message should appear. How would this be coded in VBA? Thank ya'll -Paladin
  6. Q

    SharePoint: Linking to a workbook in a restricted folder

    I have no problem linking one workbook to another, but I have a workbook residing in a folder in SharePoint and access to the folder is restricted. I want to create a workbook in another unrestricted folder that is linked to the original, so others can still view the contents of the workbook. •...
  7. B

    vba: restrictions Issue

    I am having trouble running the code below. I have resricted values in the cells using data valadation. Is there a way if the code below is used that the restrictions are took away ??? Sub Brackets() ActiveSheet.Unprotect With ActiveCell .Value = .Value & "(pcs.)" End With...
  8. M

    locking one parameter in a pivot table

    Every week I send a report out to a bunch of sales reps. The report is basically a pivot table that pulls from a data worksheet. Each rep gets the same pivot table setup, with a single parameter changed: their own name, of course. The reps are not allowed to see each other's numbers. So in...
  9. Rauber

    Solver in VBA

    How do I put restrictions for the code in VBA to apply Solver? I wanna know the way that i can link the following Code: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) ActiveSheet.Unprotect ActiveSheet.Range("y1.").GoalSeek 0#, Range("TK")...

This Week's Hot Topics

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
Top