Logon Box - User / Pass - Unique Actions Per User.

Apr 2, 2009

I have a workbook that is used to track overtime hours worked through the year. I've received some help from users on this forum, and others, to create the necessary macros and formulas to allow a supervisor to make use of the form; however, the workbook is also used to track those that wish to volunteer to work overtime each weekend. The sheet has a list of names for the employees on each shift, then a column to allow a "Y" to be placed under the date - designating them as a volunteer for any overtime available. I've found this spreadsheet (attached - from this site) that will allow individual users to access the workbook and have unique passwords for each. I don't completely understand how it works, but I feel it may be a start to getting what I want.

Essentially, once the user selects their name and inputs their password, I'd like the workbook to be opened and then allow them to only manipulate the row associated with their name. That row will change from week to week, so specific numbers will not be able to be used, but their name will be the same as the name used in the logon.

I feel like I'm asking for a lot here, so just some initial guidance on whether this type of thing is possible would be an acceptable answer.

View 9 Replies


Fill Combobox Dependent On User Logon

Mar 2, 2012

I have a logon screen and would like to fill a combobox dependent on which user logon.

If User1 logon - options 1,2,4 must be in dropdown list
if User2 logon - options 2,5,6, must be in dropdown list, etc....

View 5 Replies View Related

Pass Value From User Form To Code

Jun 24, 2006

I have created a custome User Form with three option buttons inside a frame. How do I set the value for each button and then how do I pass that value back to the code that opened the form (after closing the form upon a selection?

Sub Test2()
Select Case List
Case 1
Range("b1").Value = "List 1"
Case 2
Range("B1").Value = "List 2"
Case 3
Range("B1").Value = "List 3"
End Select
End Sub

in the form I have the following code associated with each of the butons (but I do not think I have it right). Isn't there a way (becasue I have them in a frame) to shorten the code?.................

View 8 Replies View Related

Collect Date From User And Pass To Variable

Sep 9, 2006

I have an existing macro which I am enhancing and I would like to have the user provide a date, either with a popup text box in a userform and then use a command button to hit OK and have the box dissapear, or in a calender which the date is selectable, and the date supplied go into a variable.

View 2 Replies View Related

Pass Ranges To User Defined Function

Dec 28, 2006

I am trying to write a User Defined Function in VBA to perform a simple two-dimensional table lookup. I have the temperature distribution in a solid given in a table in Sheet2. The first column of the table contains the time values, the first row contains the spacial values (radii), and the intersections contain temperature values. These ranges are named times, radii, and temperatures. In Excel, I can perform the lookup using: =index(temperatures, match(time, times, 1), match(radius, radii, 1))

But how do you do this in VBA? More specifically, how do you deal with passing ranges to the WorksheetFunctions?

Function temperature_ref(time_range As Range, radii_range As Range, temperatures_range As Range, time As Double, raduis As Double)

r = WorksheetFunction.Match(time, time_range, 1)
c = WorksheetFunction.Match(radius, radii_range, 1)
temperature = WorksheetFunction.Index(temperatures_range, r, c)
End Function

This function would be called (from any worksheet) as..................

View 4 Replies View Related

Display Number Of Lines Which Depends On Value Pass By User

Jul 17, 2013

I am trying to display number of lines which depends on value pass by user. Actually user is passing some value. On which some group of lines has to be display.

for 1 value 9 lines
for 2 value first 9 lines + another 9 lines
for 3 value first 18lines = 9 lines
and so on till 52.

View 2 Replies View Related

Pass Element Of User-Defined Data Type

Oct 17, 2007

I have an array with structure, i.e. User Defined Type. Assume the user defined type has two elements: Element1 and Element2 and array name is Array.

So the definition is:

Dim Array(1 To 10) As UserType

and access to elements is


The problem is that I need to pass the whole set of Element1 or Element2 to a function. Should it have been two separate arrays, it would not be a problem. But because of the user defined structure I have no idea how to pass a single element.

I hope there is another solution rather than to use loops. I have many arrays like this with complex structures. I simply can not replicate all of them.

View 9 Replies View Related

Pass Multiple Non-contiguous Ranges Into A User Defined Function

Dec 23, 2009

I am trying to call a function that calculates forecast error (wMAPE). This function needs to be able to handle passing in non-contiguous ranges. I can't seem to figure out how to do that.

Function wMAPE(Forecasts As Range, Actuals As Range, Weights As Range) As Variant
Dim Denominator As Double
Dim Numerator As Double
Dim i As Long
Dim Fcst As Variant
Dim Act As Variant
Dim Wt As Variant

If Forecasts.Cells.Count Actuals.Cells.Count Then MsgBox ("Error: Arrays not same size")
If Forecasts.Cells.Count Weights.Cells.Count Then MsgBox ("Error: Arrays not same size")

Denominator = 0............

View 9 Replies View Related

Unique Value In User Form List Box

Jan 24, 2007

I have created the attached file and would like to do the following using user forms:
1) From the sheet 'Courses', select a course on schedule it on a date - No problems, done this using form 'Schedule Course'

2) I would then like to assign people to courses scheduled using 'Attendees' form - this is where I am stuck and will appreciate some help. Problems faced are:

I need to schedule the same type of course more than once however I want the user to have only one selection from the drop down list (Spin should appear only once even though I have 4-5 scheduled) - he should then be able to select one of the dates for when the course has been scheduled

View 9 Replies View Related

Making Excel File Accessible For Few Users But One User Should Not See Other User Entries

Jul 11, 2012

I have an excel file with multiple sheets. I want my HR team to update that file, but one user shouldnt see the entries of other users. I want to make a consolidated file out of three files. This excel template is for salary input.

View 3 Replies View Related

Prevent The User From Saving The Data Input From The User Form If Any Of Those Three Fields Is Left Blank

Feb 9, 2010

I have a user form that has a combo box "City" two text boxes one called "Flight" and the other "Date". What I'm trying to do is to prevent the user from saving the data input from the user form if any of those three fields is left blank. The code that I have so far checks all of the required fields, if any are left blank a message notifys which field(s) is left blank and return the focus back to that field. But the rest of code also fires.

What I really need is either to stop the code if any fields are blank and return the focus back to the blank field, the user completes the field(s) and clicks the save again, or better yet, pause the code until all the required fields are completed and then complete the save. (There is actually another 200+ lines of code in this sub, but I deleted it to keep the post a little shorter.)

View 2 Replies View Related

Exl2K User: Sheet Is Password Protected But User Can Change Color In Unlock Cells

Jun 16, 2006

find attached zip file . if you open the file then you can understand the problem.

I need to change cells color and text color as per user choice in Password protected sheet : (user is useing excl2000)

Kindly open attahced file i putted the note inside the file.

View 3 Replies View Related

Check A User Input To See If The User Has Entered The Date Correctly

Feb 17, 2010

I am trying to check a user input to see if the user has entered the date correctly. I am using the code below but it keeps giving me a "Type Mismatch" error.

View 2 Replies View Related

Prevent User From Accessing The Excel File When It Is In Use By Another User

Jul 22, 2013

An Excel file named CLEARING is availble in thr central server system. it will be accessed by 5 or 6 staffs from some other systems what i need is when one person accesses/edits this file the others should not even able to open in the read only file ,when the file is saved and closed ,then only the next person should access it

View 1 Replies View Related

Unique User Input From Variably Defined List

Jan 8, 2008

Is there a way to prompt the user to pick an input composed of the values in a given column. Also, if there are repeats in the column, those need to be ignored.

View 9 Replies View Related

Prefill Text Box In Userform With Today Date But Allow User To Enter Unique Date

May 29, 2014

I have a workbook that I'm using to tracking staffing patterns within a mental health agency. When the workbook opens the user is asked to pick a date range and an office location. I've placed code into the userform that pre-fills the "start date" with today's date and the "end date" 7 days from today's date. I would like the user to be able to enter a unique date range should they wish but I have yet to figure out the coding to accomplish my goal.

[Code] .....

Attached File : Staffing Report 1.90.xlsm‎

View 7 Replies View Related

User Forms- Create A User Form That Will "pop Up"

Oct 25, 2007

I have a spreadsheet with the following headings:

Claims Number





I need to create a user form that will "pop up" and ask the administrator to enter the above details.

A - should be created automatically (ie last claim number + 1)
B - user enters manually
C - data retrieved from a list
D - data retrieved from a list
E - date is the date the information is entered

View 9 Replies View Related

Get User Name :: Windows User Name?

Dec 8, 2009

How can I set a TextBox in a user form to the Windows's User Name?

View 6 Replies View Related

Get User Name :: For File Used By Another User

May 13, 2004

how to get informazion with VBA code about the name of the user who opened already a workbook on the network.

Usually if somebody wants to open a file that is opened by another user, office applications give informations that the file is open and about the name who opened that file.

Is it possible to get this information with VBA code, too?

View 9 Replies View Related

How To Get Logon Name

Jan 22, 2008

I need to find out how to obtain the user logon name when the excel starts up in a more secure way. At the moment I am using the function environ('username') to obtain the name. However, it can be tempered by adding 'Set USERNAME=xxx' to the Environment Variable list. Is there a secure way to find out who logged on such as by interrogating the Active Directories?

View 9 Replies View Related

Log User Changes

Jul 28, 2007

I am trying to integrate an optimization model to a simulation model using VBA in Excel. I am using ShellandWait and calling some batch files to call scripts for application command line operation. Everything ran fine until I tried to read in additional data using modules from an Excel add-in that I customized (err, more like butchered actually). Now, as far as I can tell sporadically (the call to the new module occurs randomly), Excel just closes in the middle of the simulation. Are there certain types of errors that behave this way? Is there someway to view or create an error log or similar, that I can go over after the crash?


I actually solved the problem (it was a database timer expiration initiated in a fortran routine by the customized add-in). This was just pure dumb luck - in effect, I was trying the brute force approach and happened to hit the solution relatively early. If anyone knows of some method of logging Excel or VBA activity (I guess that is the right term)

View 2 Replies View Related

Save Workbook NT Logon Name

Sep 15, 2006

I have a workbook containing a few scripts that is used by a few people over the network. I'm wanting it to autosave when run (I have the code for this), but want it to include the user's NTLOGON in the file name. I'm using Excel 97 on Win NT4

View 4 Replies View Related

User Name And TimeStamp

Dec 29, 2006

Is there a way to put a time stamp with the users name into an adjacent cell when a cell is updated?

In case that didnt make sense I will tell you what I need this for. We are creating new time cards that require both employee and manager approval on them. We have many remote employees and getting their signature can be a pain. If they could click a button on the time card that stamped their name and time that would be ideal. They would then send to their manager they would click to verify the time and it would stamp it as well.

View 12 Replies View Related

User With AutoSum

Apr 3, 2007

I have a user that is having problems with AutoSum updating after a cell is deleted. He has the following...



If he deletes one of the cells, (lets say 200), the autosum number stays at 400. I reinstalled his MS Office and it worked for a few days, but now he is having the same problem.

So now he has...



View 9 Replies View Related

Add A User Name To Spreadsheet

May 6, 2007

I have designed a spreadsheet in the office where I work, and think it would be quite flashy (gimiky) if I could have the spreadsheet show the name of the user logged on.

At the minute if I try and access a sheet currently open by another user it will come up with the standard message 'workbook1.xls is currently in use by xxxxx' then you open a read only copy until they have finished.

I was thinking there must be some way of importing this information to excel to display something like 'welcome (xxxxxxxx)(user currently logged on)'

The other part of my problem is that the excel sheet will only display the network uername of the user, but I have seen spreadsheets that cross reference this to the Microsoft Outlook global address list on the MS Exchange server, and display the users actual name.

In a nutshell, I just want to know is there anyway the excel spreadsheet can display the username currently logged into the shared spreadsheet.

View 13 Replies View Related

User Name & Password Log In

Jun 10, 2009

I have a 3 2 user forms, plus a calandar pop-up user form. One is a Log In Screen with a user id combo box and a password textbox referenced to ranges in a very-hidden sheet.

My second form is a spend tracker with mulitple fileds, text boxes, combo boxes, etc.

One of the fields in the spend tracker is user name, what I would like to do is when a user enters their user name and password the entered user name as long as it matches one in the database be populated in the user name field and not allow it to be edited. Is there a way to do this, if so, what is the code and where do I put it.

I will attach my file so you can check it out. Log in: tester

Password: test01

Programmers Access Code is 1234.

View 9 Replies View Related

User Restriction

Jan 5, 2010

In my User Form, one of the combo boxes has names. How can I restrict this box so the name chosen is the same as the Windows user?

View 14 Replies View Related

VBA Re User Prompt

Oct 4, 2008

I have created an addin that runs several macros. To enable the user to undo any changes, I keep a backup prior to them using any of the macros in the form of a worksheet named back00xx. I want a prompt to be displayed to the user to remove these backups at the closing or saving of the file. The problem is that as an addin, how do I get it to display this prompt as the open workbook is not part of the addin.

Could one have a looping routine that is checking every xx min/sec to check if the current workbook contains any sheets starting back00

View 9 Replies View Related

Retrieving User Name

Nov 14, 2008

When I run it it returns in A1, Jeffrey.Brown2. I would like to turn this into Brown, Jeffrey but because another user may have a shorter or longer name the Left & Right function does not work for every scenario?

Sub who()
Range("A1").Value = Environ("username")
End Sub

View 9 Replies View Related

User Form

Feb 24, 2009

I have a user form that I want to take the information and have it input on the worksheet. I want it to start at A3 and check to see if that cell is "" and if it is not then enter the data from the from horizontally. If A3 is not "" then continue down column A untill the first nonblank cell is and then select that cell and have the data entered horizontally.

I have this code so far but it is not working.

Private Sub cmdSubmit_Click()
Dim Month As Variant

Month = Me.cmbMonth.Value


I have done a bit of excel programming last year but have not done any for the last 4 months so I am a bit rusty.

View 9 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved