restrict

Hello all, Is there a way I may restrict access to a page on a multi page userform? Thanks Kelly

How can we restrict only dd/mmm/yy hh:mm format in an excel cell ?

Respected Seniors! I am using the MS Excel 2013 pivot bar chart to to show some information on yearly basis. I have used the year values as "filter". Everything is working fine, except that I want to restrict the filter selection to one value (i.e. year) instead of multiple values selection at...

I already have the code in workbook module, but I have assigned it to a keyboard shortcut (Ctrl+d) and that works in all of the sheets in that workbook. What's the recommended way to restrict the macro so that it only runs when called from one sheet? Can I restrict the shortcut to just one...

I want to restrict the options in a drop down list based on the data entered to another cell e.g. Country/city - is the user selcts USA as the country, they can only selct cities in the USA not UK, Germany etc although they will also be in the source data. Be greatful for any help

I need to restrict data within the cell. Here is the scenarios: Within the cell: AA:BB:CC:DD:WW:ZZ 1) Total character = 17 <colgroup><col><col><col><col span="3"><col><col span="2"></colgroup><tbody> 2)Allowed Numbers or Upper Letters Only 3)On the 3-rd,6-th,9-th,12 and 15-in position...

Help needed with this one please everyone.... Is there a way I can restrict cell access on the Android excel app? That's it! Thanks Pau

I am using Excel 2007 and I have a problem in drop down list. My drop down list(data validation) contains several kinds of colors, among that i can select any of the colors in parallel i can copy and paste same list of colors from across the workbook. I am able to reach the functionality till...

Hello, I am setting up a time sheet for my employers to use. There are 7 days in a week but I want to set it up in such a way that the user can only input work hours for 5 days a week and prohibit them from inputting anything on the other 2 days. For example, if Employee A worked Mon-Fri, then...

Hi, I'm sure this is really simple but I can't figure it out for the life of me. I have the following Macro: Sub UnhideRow1() Dim i As Long If columns("A").SpecialCells(xlCellTypeVisible).Count = rows.Count Then Exit Sub i = 1 Do Until rows(i).Hidden = True i = i + 1 Loop rows(i).Hidden =...

Hello, I am having an issue restricting a cell to only what is in the drop down. I have a cell that is data validated as a list to be passed this: =IF(B4="Lease",$O$3:$O$6,INDIRECT(VLOOKUP($P$21,$O$2:$S$17,5))) the indirect passes a range for example "O2:O11" which would fill the drop down...

Hi, I need support on how to do a multiple data validation entry in the same column (Same cells). I want to restrict the entries in B1 to B20 to only "X" and "B" in a drop down menue in each cell. (easy, just do a data validation and choose list. BUT, I also want to restrict the entries to...

I need to restrict the excel cell to specific format. the entering data must start with alphabet and may or may not contain number after the that and the data must not contain any special characters Valid formats: tarun00197u tarunkumar345ever Invalid formats: 4tarun 34tarun tarun00197%-4u...

Is there a way to restrict a macro to run only a specified number of times during a user designated time period, for example run no more than 3 times during a 24 hour period? We have a macro that runs to alert maintenance personnel if a certain temperature condition is met in machinery. This...

Greetings all, Is it possible to set conditions on a cell that would make it unusable (blocked out from editing, filled in black?) If A2 is $500,000 or more: B2 populates with "YES" If A2 is under $500,000: B2 is disabled from edits, filled in black Wasn't sure whether this was possible...

Good Morning, Using Excel 2000 I am trying to create a register to aid configuration management. Column B will contain unique IDs, alphanumeric and four characters long. I wish to restrict the input format to unique entries only, four characters in length and also upper-case if possible...

Hi everyone. I have a spreadsheet that users will have to populate. Some cells are totally locked, others are available for users to input data, others have data validation (lists). The first question: I want users to be able to Paste as Values in certain cells (ie, I don't want them to just...

I have been using the following code to only allow the user to enter numbers into a text box on a userform. I am needing to use a similar code to this on a named range to restrict the user from entering certain characters. I am not too sure how to manipulate the following code to make it work...

Hello to everyone. I hope I can find help here again with my Excel issue. The scenario is the following: I have an array of five cells where whole numbers greater than zero will be input by the user. When the user inputs data into any single one of those array cells, they will then be...

Hi Gurus.. I have a textbox where I want user to only type in manually and not copy any text from somewhere and paste it into the textbox. How do I disable the paste option when the cursor is in a textbox. This is what I tried and the reason it failed: Private Sub txtPassword_Enter()...