Is There A Way To Protect The Userform Fields
Nov 10, 2007is there a way to protect the userform fields or the userform as whole from other people entering date accept the person who has been given the privilege to enter data?
View 14 Replies
ADVERTISEMENT
Password Protect Certain Fields Userform
Jul 24, 2006I have a userform that is used to search and display complaints in the complaint Database. I am trying to achieve following to make it professional:
1. Is it possible to provide users with their own username & password, so that I can give permission to certain users to enter their input. e.g. when a complaint is logged, the owner of the complaint (which will be allocated by me depending on the complaint Category) needs to enter his feedback into a field (a textbox) and close the complaint. I want to give this previlage only to 2-3 nominated users. Every other user will just be able to enter & view complaints.
2. Is is possible to colour code these. Just so that when a user does and a search and views any particular complaint, it will tell him whether that particular complaint is open or closed. So may be closed complaint can have a red complaint number and open ones have a green. Any other ideas for displaying this are also welcome.
Send Data From Userform To Worksheet AND Send Userform Fields In Email?
Jul 12, 2014I have used a database template from this site and changed it to suit my needs but I have a bit of a problem with some of the code. I know how to update the worksheet with the relevant userform text fields and in another project I did I have successfully sent userform text fields in the body of an email.
For this project I want to update the worksheet AND send an email at the same time. However, using the two pieces of code together is causing an error that I can't seem to solve (using my very limited vba knowledge!). The code I am working on is below and I have highlighted the line that is getting the error message. C
VB:
Private Sub cmdSubmit_Click() 'Submit new record
Dim ws As Worksheet, lRow As Long, Str As String [code]....
UserForm Tabbing Through Fields Sometime Tabs 5 Spaces
Jan 20, 2007I have a Userform containing Textboxes and ComboBoxes.
On all of the textboxes the TabKeyBehavior property is set to False.
Sometimes when you are typing either a textbox or a Combobox when you hit the Tab key to tab to the next field it tabs you over 5 spaces instead of going to the next field.
Anybody run accross this and find a solution to it. I have only run into this with excel userforms and never in Access db forms.
Protect And Unprotect All Sheets And Workbook Using Userform Interface And Password
Jul 6, 2012I am trying to create a way to protect and unprotect all sheets and the worbook by means of a Userform pop up interface.
I have managed to create the Userform but what the code will look like and where to place the VBA code that will make it work, Also i would like to automatically save the sheet/s as i switch between them. so that any updates made to the sheet will be automatically saved when i move to the next sheet and also when i protect or close the workbook.
Access An Userform For Multiple Users With "protect And Share Option"
Apr 27, 2009Is it possible to use the userform when it is protected and shared.
I am able to access when it is protected. but unable to access when that protected worksheet is shared.runtime error message " unprotect method sheet class failed" appears it is shared and used.I have already raised this [b]issue in the forum.I understood from the answers that it is not possible.
" My requirement is multiple users should use the form and they should not have the access to edit the entires made by them"
Please give me a solution.
" Being a moderator myself i should only be able to edit or modify the entries made by the users."
Note:
I dont want to create multiple excel sheets for multiple users.i want to use a single excel sheet (Shared and protected)
Also provide me an alterante solutions if any
Password Protect Columns - Hide And Protect Ability To Unhide
Jan 17, 2013Some sensitive data is held on worksheets that are used by people that do not have access to see the data.
It would be most convenient to keep the data in these worksheets but hide it from view of the users.
Is there a way to password protect a users ability to unhide a column?
Password Protect: Unlock The Worksheet, Autofilter It, Print It, Unfilter It, And Password Protect The Sheet Again?
Jan 12, 2007I have a sheet that is password protected. I have this code attached to a command button. It will unlock the worksheet, autofilter it, print it, unfilter it, and password protect the sheet again. However it is protecting it without a password. I need to have it protected with the password so that someone will not be able to just go to tools to unprotect the sheet.
Private Sub CommandButton1_Click()
ActiveSheet.Unprotect "rainforest"
Columns("O:O").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=">0", Operator:=xlAnd
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter Field:=1
Selection.AutoFilter
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowSorting:=True, AllowFiltering:=True
End Sub
Convert Column Data Fields To Row Data Fields In Pivot Table
Feb 8, 2014CountryHourDataTotalData
Austria - A10Sum of SeiA51CountryHourSum of SeiASum of SeiT
Sum of SeiT4.88Austria - A10514.88
1Sum of SeiA561562.83
[Code]....
left side pivot created in vb 6.0 & right side pivot table created manually in excel.
i want to generated pivot table using vb 6.0 same as right side pivot.
Set PRange = ws1.Range("R1:Y" & finalrow)
Set PTCache = wb.PivotCaches.Add(SourceType:=xlDatabase, SourceData:=PRange)
Set PT = PTCache.CreatePivotTable(TableDestination:=ws2.Cells(1, 1),
[Code]....
Merits Of VBA Protect Vs Non-Protect
Jul 26, 2006I would like to protect the intellectual property of an application and have read differing opinions of the merits of protecting VBA code. What are the opinions of the experts on this forum? Are the password breaker programs so advanced that protecting code is a waste of time and only a hinderance to debugging and troubleshooting?
I am using MS Excel 2003 (11.5612) on XP.
I apologize if this topic has already been covered on this forum. I searched but did not find exactly what I was looking for. I am happy to review an old post if one exists.
Can't Get Rid Of Values In Sum Fields
Mar 24, 2009Although I have removed the original numbers in the main area (I12 - AM12), there are still values in the fields I11 - AM11 that just won't go away. These formulas merely sums up the columns below as far as I can see so I can't figure out how come the values 101, 98, 9o etc aren't '0' since there are no values to add anymore..
NB!Not sure if the formulas will be in norwegian or if they change based on language settings but think you will be able to figure them out regardless..
('HVIS'=IF)
Matching Name Fields
Oct 23, 2009I have a list of company names and I need to find the duplicates. Of course pivot table finds the exact matches, but how do I find duplicates when only 1 character is off. Like punctuation or "s" or a mistype of a single character?
Example:
Jo Blo inc
Jo Blo inc.
Jo Blo inc
Jo Blo icn
Joe Blo inc
Jo Blo inc
Sum Fields Across Worksheets
Nov 12, 2009I have a workbook that is used to calculate sales & commissions for our sales reps. The majority of the worksheets are "RepLast, RepFirst". All of these Rep worksheets include an identical format. I need to add another sheet which grabs the total quantity of products A for each rep and sums them on the new sheet. And repeats the process for products B to Z.
Is there a way to do this other than longhand naming each rep and then the field in the worksheet? We are regularly adding new reps (and losing some periodically), so I would prefer to not have to regularly update the longhand formulas (i.e. ='RepName1'!A25+'RepName2'!A25+'RepName3'!A25...etc) as that would seem prone to introduce calculation errors.
Autopopulation Of Fields
Aug 25, 2007I have a rather unique problem with a new workbook I have created and it only affects 2 sheets out of the the entire thing.
The sheet is driven by a name:
Schmoe, Joe
Diddly, Bill
These names are picked from a drop down list. When a name is picked it autofills other fields using the LOOKUP command:
=IF(A3="","",LOOKUP(A3,Roster!A2:A181,Roster!C2:C181))
By now I think this is pretty straight forward and works wonderfully well for the other 50+ sheets. However I have two employee names where the second of the two (Diddly, Bill) takes and autofills the fields with Schmoe's information. The only thing I can randomly pick up is perhaps the employee numbers are too close:
00868
Mandatory Fields
Sep 28, 2007i have created a form hich dumps into a database.
There are some mandatory fields which need to be filled in by the user on the form - how can i flag these up at the end of the form - with a message box which says - "cant complete - feild "" "" "" are missing "
How To Add 0.00 In Empty Fields
Feb 26, 2008I have a spreadsheet that I receive with a column containing some numbers. It arrives in genearl format but as part of a macro I format Column "C" to 2 decimal place numbers.
This works fine but some of the cells are completely empty. I need to have those empty cells populated with "0" which will of course display as 0.00 because of the formatting.
How To Repeat Fields In A SUM
Feb 29, 2008I had a spreadsheet with 45 fields, endind with a SUM in field 47.
I've inserted new fields, exactly 531. The SUM doesn't know that and still thinks that I have 45 fields:
SUM(F2;F5;F8;F11;F14;F17;F20;F23;F26;F29;F32;F35;F38;F41;F44)
How do I add automatically the value 3 to F44, continuing to add the value 3 to 531? So I want:
SUM(F2;F5;F8;F11;F14;F17;F20;F23;F26;F29;F32;F35;F38;F41;F44;F47:F49; F52; ETCETERA)
Indirect Fields
Sep 29, 2008I am trying to figure out a solution and wondering what would work the best. Here is my situation. As an example, I have one big database with fields such as:
Item# Date Qty Price Cost ect...
1 3/4/08 3 $9.00 $7.00
2 9/5/08 5 $8.00 $6.00 ect....
This continues for up to 1000 lines from a database. I have this is a tab called "Database". From the data in the tab "Database", I want to be able to create 4 seperate reports.
The first report might only have the columns "Item #" and "Date".
The second report might only have the columns "Item #" and "Qty".
The 3rd with only "Item #" and "Price"
The 4th with only "Item #" and "Cost"
If I create a new spreadsheet called "Sales" and create the following:
ColA = Item #
ColB = Date
SQL Naming Fields
May 14, 2003I'm in the process of writing some SQL in excel and normally when I want to specify a field name as another name say wx22 as Part Number i just use square brackets eg
"select wx22 as [Part Number]"
Delimiting Fields
May 18, 2006I have a field that needs to be split into a set amount of columns depending on a delimited character. This works fine with all of your standard delimeted characters such as / or ,. The only issue is I have a field that has a delimiter of the square symbol . How would I be able to insert this symbol into a input box. When I try and copy the symbol from excel it does not show in the inputbox. I also tried to copy it from the sybol that can be generated in word and that just pastes as?. I was wanting to know if there is anyway this can be entered into a variable so that I can delimit the data using this symbol. If I have to use a ascii value I don't mind I just cant find a ascii code for it.
View 5 Replies View RelatedFields That Will Update Each Other
Jun 21, 2007I'm creating a spreadsheet that will have two types of data fields: hex and binary, with pairs of corresponding values for each record in the worksheet. I need to be able to edit the hex values and have the binary values update correspondingly and vice versa, on the same worksheet. I can't figure out how to create such a two-way feedback mechanism.
View 5 Replies View RelatedMatching Two Worksheets Using Two Fields
Mar 2, 2013I have two worksheets. Each have a common value in two cells. An ID and a currency amount. One worksheet also has a payment date. I need a worksheet that combines the two, along with the payment date.
View 3 Replies View RelatedUsing The Same Header In Multiple Fields
Apr 25, 2014So, I've created a pivot table and need to use one of my values in both the row and value fields. I haven't seen a way to easily do that so far. Is there something I'm missing or is this not possible with Excel (yet)?
View 3 Replies View RelatedFind And Match Fields
May 7, 2014I have a workbook with two sheets, one used for referance (Column A - Product SKUS, B - Product Description and C - Carton Quantities) - Sheet 1
The other sheet I would like to import incoming shipments. (Column A - Product SKUS, B - Product Description, C - Quantity Ordered and D - No of Cartons) - Sheet 2
What I need to do is find out how to get Excel to find and match up the SKUs in Col A and then dividing Sheet 2's column C by Sheet 1's column C to give the number of incoming cartons of each product in Sheet 2's Column D
Check Value In Two Fields - Give Value In Third
May 15, 2014I have a excel sheet with 3 columns. In column B and C there is either a number, or empty. If both for instance B1 and C1 is empty, i want A1 to automatically be filled in with the number 1. If there is value in one of them, then i dont want anything in column A.
View 3 Replies View RelatedSum Formula For Non-numerical Fields
Nov 21, 2007I have a column of dates (2007, 2006, 2005 etc...) and a column of data ranging from "unsatisfied" to "very satisfied". I want a formula to provide, for example, the total number of occurences of "very satisfied" in "2006".
View 9 Replies View RelatedUse Two Fields To Determine Lookup Value?
Jun 9, 2009I'm sure it is possible to solve this with an array, despite all my efforts having produced nothing so far. Attached is an example workbook. On the 'Data' sheet, every month the data will change and I need to fill in column A, with the approriate Name from the 'Map' sheet. Is this possible using an array?
View 3 Replies View RelatedVlookups And Editing Those Fields
Jul 7, 2009I am trying to create an asset management database using excel, and would like to be able to add custom notes to each entry (index) so as time goes on, I can refresh my memory what we have done with a particular item. I have attached the current file I have created.
Essentially, when I use the GREEN drop down menu in the top right, I want it to display the notes/comments that I enter in the rightmost column of the data, as the attached file illustrates.
However, I want to be able to hide that rightmost column and be able to edit the data from the new area (white space) it is being displayed in, however as I have it set up right now, if I edit the cell, it edits the forumla and poof goes all the comments and the formula becomes messed up.
Mandatory And Interdependent Fields?
Aug 21, 2014I have a form (Excel, of course) which needs to be filled following some criteria. I have a filed name "Clause of non-compete" and you have to choose between YES and NO. This field has to be mandatory. I did that with the following code (see below). Now i have another field that says: If YES, should it be maintained? How can i make the second field to be dependant on the first one and mandatory? I want it to be mandatory only when there is Yes in the first field (merged field N35:O35).
[Code]....
Select Fields At Randomly
Apr 11, 2008I have a workbook with sheet 1 called Support which is basically an input form. The second sheet is called Database.
I want to enter data into the form and via a macro copy the data to the database. I have followed a text book to the letter on how this is to be completed to the letter.
My problem is that when the data is written to the database some of the fields are blank. Using F8 I can step through the VB script which appears to select fields at random.
