How To Restrict Users From Logging More Than Once In Excel

Nov 7, 2011

I am doing an excel survey using forms. I want to restrict users from completing the survey more than once. i am using below code to input user login details in to a spreadsheet but i am not sure how to restrict them. I want a msgbox or some sort and then it closes the excel active workbook.

code to get username:
Sub GetName
Dim r As Range
Set r = Sheets("UserNames").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)

r.Value = Environ("username")
r.Offset(0, 1).Value = Date
r.Offset(0, 2).Value = Time

End Sub

After looking through various forums i found code to highlight duplicates but not sure how this can be modified to suit my need.

Code to find duplicates:
Sub Dups()

Application.ScreenUpdating = False
Sheets("UserNames").Range("A1:A500").Select
Rng = Selection.Rows.Count

[Code] .......

View 5 Replies


ADVERTISEMENT

Restrict Users To Only Editting Certain Cells?

Apr 6, 2009

I need a way to protect my worksheet from any changes but allowing the users to edit certain cells (eg. allowing users to enter data only into columns A-G).

View 2 Replies View Related

How To Restrict View For Users Of Spreadsheet

Feb 9, 2014

I've written a spreadsheet for others to use, protected it (except for cells where data input is required). Almost like an App for sales people to prepare quotes. I want it to appear fullscreen only with formula bars and headings permanently hidden so feels the experience for the User is similar to an App.

View 9 Replies View Related

Restrict Editing To Certain Columns/Rows And Allow Some To Be Edited By Users

Oct 29, 2007

how do I restrict editing to certain columns/Rows and allow some to be edited by users?

View 2 Replies View Related

Need To Restrict Excel Shortcut Keys Commands To Run

May 2, 2013

I'm working on a VBA program prepared for accounting purpose. In that program i hide the excel ribbon by custom UI and also need to restrict excel's shortcut keys commands to run.

Can i do this with some VBA code.

View 2 Replies View Related

Excel VBA - Restrict Cell To Input Manual Entry

Apr 3, 2012

I am using the below code to enter the data in Cell "D" & "E" of the worksheet.

Dim a, b As Integer
a = WorksheetFunction.CountA(Sheet2.Range("C:C"))
ActiveWorkbook.Sheets("Retailing Data Sheet").Activate

'If Range("C" & a + 1).Value "" Then

[Code] .......

But, If someone wants to enter the data manually into the Cell "D" & "E" its allowing which i dont want.

It should be enter by using the form only...

View 5 Replies View Related

Restrict Excel Data Form Only For Appending New Record

Jan 11, 2007

Can I Restrict Excel Data Form only for appending new record. (No deletion allowed) and also Can I save Data Form in the File? Is there any way, whenever we open the file Data Form should popup?

View 9 Replies View Related

Excel 2010 :: Data Validation - Restrict Value User Can Enter Into A Cell

Oct 2, 2012

I'm using Excel 2010, and I need to restrict the value the user can enter into a cell (E9).

In cell E3 is the screen width (pixels). eg 6024
In cell E5 is the preferred width of a window. eg 450

The user, in cell E9, enters an x coordinate for which they prefer the top left corner of the window whose width is specified in E5.

If the value that the user enters in E9, added to the width entered in E5, exceeds the value of E3, (if E9+E5 > E3) then the value should be disregarded (window will be off right of screen) and the user re-enter.

I'm not familiar with the use of data validation, so I'm uncertain as to how to use it in this circumstance.

View 3 Replies View Related

Outlook For Multiple Users Or Excel?

Apr 23, 2013

I'm trying to identify a way of setting up a booking system for some meeting rooms we have at work. Always looking for a way of simplifying something that soaks up one of my colleagues time.

I read this post about a golf booking system and it looks like it could be adapted to suit, I can imagine a different worksheet for each room and the fields for entry on choosing the timeslot being the meeting title, who booked and a contact number and the slot showing the meeting name when hovered over possibly.

I noticed a similar thread about Outlook, I know nothing about this sort of stuff within Outlook and not sure it may be possible. I am just in my infancy with hyperlinks and macros and do not feel confident enough to start there as I do not know where to begin. Keen to learn and would love to figure out and play around within a program; learn best this way.

View 6 Replies View Related

Users Can't Update Excel Link

Jul 9, 2013

I have created a spreadsheet that consists of a link to an Access query. Everything works fine for me. I have put the database in a location that is accessible by the people that I want to use the spreadsheet but when they open it they get the error : "The query did not run or the database did not open."

View 1 Replies View Related

Multiple Users In Excel File?

Aug 1, 2013

I was wondering if it's possible for several users to be working in an excel file at the same time? I know that 1 person can be working in a file & other users can look at it in Read-only, but is there any way for more than 1 user to be WORKING in it at a time?

View 4 Replies View Related

Users In Excel :: 50+ Running Slow

Dec 2, 2009

I have built an Application in Excel that is used by a userbase of 50+ people. Now, as standard, they are only able to access the document read only. The application writes data to an ".mdb" but the user cannot change the application directly istself.

Now, we've had the problem over the last few days that the program is running slowly when it is trying to write data back to the ".mdb" file.

I believe that it could be because connection to the sever that our application is running slowly (or the server is too highly trafficed) but our server team are telling me there is nothing wrong with the server and it's running slowly because there are too many people in one Excel application/

View 9 Replies View Related

Logging In A Website With Macros

Dec 12, 2008

I'm trying to automate some webscraping on a website that requires a login, and was wondering how I would do so using Macros with a specific username password somewhere in the spreadsheet, lets say B2, and C2 respectively. The website I'm trying to login is this; http://underground.chacha.com/account/. I think I have most of the scraping figured out; its just the log-in for now.

View 2 Replies View Related

Recording/Logging Cell Value When Value Changes

May 8, 2009

Is there a way to copy/transfer a cell value to an adjacent cell when the value of the cell changes. So if A1= 5, and it changes to 3, have B2 = 5 when this happens.

View 14 Replies View Related

Automated User Logging

Oct 1, 2009

I keep a spreadsheet with the 50 or so wireless phones in our "lab". When someone checks them out, the rules are that they change the cell under Available to "NO" and add their user ID. When they return the device, they change the Available cell back to "YES". What I want is a log of who checked out the device, and when... which would be kept in "sheet 2".

I attached a small spreadsheet with the same columns and information you would see in the regular spread sheet. Sorry, I would rather have put it here, but I couldn't figure out how to do that.

The spreadsheet has code which updates the "Counter" when someone checks out a device. Many thanks to the "Rocket Scientist" who helped me with that.

View 11 Replies View Related

Logging Changes To A Worksheet Range

Oct 29, 2009

i have a spreadsheet with the following range in a worksheet called "Data".
The range is A3:CH9 where column A contains the data label and row 3contains a label for each month. So the data itself is in B4:CH9

Is it possible to set a macro that logs any changes to the data in the range
B4:CH9 and log that change in another worksheet (eg: "Log"). It would say who made the change (based on the USERNAME), what cell was changed, when it was changed and what the value was changed from and to.

View 10 Replies View Related

Logging Live Data

Nov 30, 2008

I'd like to log live update data continuously,i.e. as the data in the cell changes. The problem I'm facing is that the data comes in at uneven intervals-- ranging from 30 to 50 ticks per second. So I can't really use a timer function. I need to use some function which saves the data as the cell value changes. So, for example, if cell A1 gets updated continuously, cell B1 could save the first value of A1 and then cell B2 could save the second value of cell A1-- and so forth.

View 9 Replies View Related

Use Vba To Create Copies Of Excel Workbook For Different Users?

Nov 26, 2012

I have an excel workbook that serves as a master workbook. I have to create 30 copies of this workbook, 1 for each site. Each workbook will have small differences in the data held. This is because I will refresh the sheet before saving it. There is a dropdown list on the 1st tab of the workbook that contains the names of the sites. The sequense, I suppose would be like: select the next name on the dropdown list"calculate" the spreadsheet to enable the refreshsome sort of "save-as" with the name from the dropdown list forming the name of the file. The Master file must be kept intact.select the next name from the dropdown listcalculate the sheet ........and so on I have a few other things I will add to the script like Protect Sheet etc.

View 1 Replies View Related

Excel 2010 :: Links Not Working For End Users

Jul 12, 2013

I am using Excel 2010 on Windows 7.

I copied (with 'Paste Link') rows from a master Excel file to a file that performs calculations. This file (and many others like it) need to be modifed by other people. My tester has informed me that the data is not updating between the files for her, although it does work for me.

When I check 'Data->Edit Links' it shows the status of the file as 'unknown'. If I click 'Check status' it is then OK, but the next time I look at it, it has reverted to 'unknown'.

1. How do I get the status to remain at OK?

2. Why do the links work for me, but not for my end users?

View 2 Replies View Related

Multiple Users In Excel File At One Time?

Aug 1, 2013

I was wondering if it's possible for several users to be working in an excel file at the same time? I know that 1 person can be working in a file & other users can look at it in Read-only, but is there any way for more than 1 user to be WORKING in it at a time?

View 3 Replies View Related

How To Stop Other Users From Deleting Excel Document

Apr 4, 2014

I have a few excel files in a common shared folder. I want to allow other users to access this folder to make changes in the worksheet but should never allow them to delete the file. How can i do this?

View 5 Replies View Related

Self Destruct Workbook After Not Logging In Within 30 Days

May 20, 2007

I need a macro that records users accessing a workbook over a network and if I have not logged in after a 30 day period it will replace all calculations with data and if possible wipe all macros.
I have tried to nut this out but time is against me.

I have had my work taken to other sites within our business and passed of as their work, and it bugs me.

View 9 Replies View Related

Excel 2007 :: Login System For Two Users On Worksheet

Mar 7, 2014

I am creating a login system for two users on a excel worksheet. I have the two users on a drop-down list, Maria and Andrew, which then requires a password entry. This is linked onto a data validation to make sure that the password matches the data table.

After, I then click on a macro, which, when successful, takes me from sheet 1 to sheet 2.

My problem is that I need to have it so that Maria is taken from Sheet 1 to Sheet 2, and Andrew from Sheet 1 to Sheet 3.

View 1 Replies View Related

How To Create Excel Add-in With Custom Dropdown Menu For Other Users

Feb 12, 2013

I've written a ton of VB macros that do various things to a raw data sheet. I want now to create a custom menu (in the the menu ribbon bar at the top of the screen). I'd like this menu to be used to activate the various macros for whoever has my add-in.

I've found several examples on how to create an add-in, and creating custom menus, however they all for when someone opens a workbook with the code, and then they remove the custom menu when the workbook is closed. I would like my custom menu to stay on the users ribbon bar no matter what workbook they have open. The only time the custom menu should not appear is if the user removes the add-in.

View 6 Replies View Related

Shared Excel Workbook Shows Different Information For Users

Mar 3, 2014

We have a Shared workbook on our Server and about 5 users work at the same time every day. I want to understand something, If I open it I can see all the information in it, all the rows and so on, but if the same workbook is opened by another user he will see other information, the rows aren't the same as in my case. Why does this happen ? I would like the second users to see the same information as I do.

View 1 Replies View Related

Sumproduct - Number Of Divers Logging Dives

Jan 24, 2014

Building a Dive Record spreadsheet and Annual Statisics requirements to compute automatically. I have gotten this far:

=SUMPRODUCT(((M$10:$M$17="X")*($B$10:$B$17<>"")/COUNTIF($B$10:$B$17,$B$10:$B$17&"")))

Unfortuantely, I do not have a list of divers names for referencing. I am using these for testing purposes:

Column B Diver's Names: B. Dodson, L. Lloyd, D. Burch, C. Haley, J. Wilson, B.Dodson, B. Dodson Columns M through BO (types of dives): will have "X's" in them if a specific type of dive was made, Scientific, Working, Training, Non-duty... Shore, Boat, Ice, Cave, etc..

I need to know how many Divers made the type of dives. For example, if I make three dives in Saltwater, L. Lloyd makes one, and D. Burch make one, the answer needs to show 3 which is correct. If Dodson makes one, Haley makes one, and Wilson makes one, the number is 2 (actually 2.33). It works in some cases and not in others.

View 7 Replies View Related

Code Reuse - Logging Actions When A Cell Changes

Apr 28, 2009

I am trying to use following codes for a add-in utility so that user can enable or disable logging activity for a given workbook.

My problem is to how to add the following code to a new workbook so that "Loginfo" function could be activated. I have tried some application... based commands but it do not seem to be working.

View 6 Replies View Related

Code Reuse - Logging Actions When A Cell Changes -2

May 2, 2009

I have made an class and created a file to log when user change value or insert formula in a sheet get recorded in a file C:Logme.csv. The problem is it is recording the value and formula at random i.e in some instances it records the value and in some instances it is not recording the value and formula in logme.csv . I am unable to figure out why this is happening?

View 3 Replies View Related

Any Way To Have Multiple Users Edit Excel Spreadsheet When On Company Server?

Sep 25, 2013

Not exactly what year of Microsoft Excel we have at work buts its between 2007 to 2010.

Doing our weekly KPI on a friday is super stressful and if there is a way so multiple users can edit the excel spreadsheet at the same time?

Because with our excel spreadsheet only one person can edit the document at a time very frustrating at the end of a day on a friday.

Is it just Microsoft not allowing more than one editor at a time?

View 1 Replies View Related

How To Intimate Other Users About Editing Record In Shared Excel Workbook

Jun 2, 2014

i have an excel database regarding about 1000 different schemes having the details of their initiation date, budget allocated , up to date expenditure, this month expenditure and many others too. this is a shared workbook and relevant officers enter their data in their relevant columns and rows. the file is shared. now i want that any changes done by mr. A, for eg. at record No. 09 could be intimated to Mr. B who is working at record No. 560. may be via msg box or any other source.

View 1 Replies View Related







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