restrictions

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

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

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

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

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

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

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

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

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