Multiple Users On Same Spreadsheet But One Tab At Time?

Jun 13, 2014

Is it possible to allow access to multiple users on one spreadsheet but they can only access one tab at a time each?

prevent multiple changes for the same thing.

View 1 Replies


ADVERTISEMENT

Calculate The Total Time Users Spend On A Spreadsheet Per Month

Aug 10, 2009

I have a simple VBS script that puts the username & current time in columns. When the user saves that time is also placed into a column.

I would like to be able to calculate the amount of time a user has spent on the spreadsheet for the current month & if possible the total time all users have spent on the spreadsheet this months.

View 8 Replies View Related

Multiple Users To One Spreadsheet?

Mar 5, 2013

We have a place where all our documents are stored. We have a log where we all log in what we're working on. Our trouble is, if one person has it opened nobody else can add their items to it. Is there anyway to have multiple people be able to open and enter their work for the day, save and close it out?

View 1 Replies View Related

Add-ins & Multiple Spreadsheet Users

May 29, 2009

I've created a model that uses an add-in to calculate otherwise cumbersome formulas, and 4 or so people need to access this model at any given time. It's saved (along with the add-in) in a public folder on our network drive. Everyone is able to access the model, and is able to load the add-in directly from that folder, but the cells that use the add-in point to where the add-in is stored locally on my drive (C:Documents and SettingsmeApplication DataMicrosoftAddIns) and thus they are not able to use the add-in functions without redirecting every reference to me with references to their add-ins (basically just by finding and replacing every 'me' with 'them' in those cells at this point). So I guess what I'm wondering is how do I make it so the add-in is 'universal' (instead of local) such that as long as each user has the add-in loaded they can fire up the model and use the needed functions.

View 9 Replies View Related

Share Spreadsheet With Multiple Users

Sep 11, 2007

I have a speadsheet, and at the moment, another spreadsheet access it via a vb code. but i have 3 - 5 agents needing it sometimes at the same time. All that happens, is the agents excel sheet passes some info to the server sheet, so the vb codes opens and closes it. So only one person can do it at the same time.. but i need this so anyone of the agents can enter info via the vb code.

When i tested it, it asked me when i opened it, if i wanted to save what the last person did, I need that not to come up, so really its like the sheet is always open, but not... and lines are added. The info is added to the same sheet, and line by line.

View 2 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

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

Function To Be Added On Timestamp Macro To Align Time Of Users From Different Time Zones

Mar 28, 2014

I am looking for a function to convert time given by my computer (Local time) in EST (Eastern Standard Time). We are several users of a same file (with timestamp macros) and all time need to be aligned to one time zone (EST), even if all users are working in different time zone (EST, CST and IST).

View 1 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

Disallow Users From Using Fromulas In A Spreadsheet

Dec 13, 2009

Is there a way to disallow users from using fromulas in a spreadsheet? I have an issue in which users are using formulas to concat data as a shortcut to typing in data but they are constantly referencing the incorrect cells.

View 6 Replies View Related

Users Of The Spreadsheet Cannot Delete The Formula

Feb 6, 2009

I have this formula in my worksheet

=sum (L12*M12*N12)

How can i put this formula into VB code so that users of the spreadsheet cannot delete the formula.

View 9 Replies View Related

VBA Code Won't Stop Users Using Spreadsheet After Certain Date?

Jul 28, 2014

The code that I'm using is supposedly not allow spreadsheet to be opened after a certain date, or does not allow a user to press any of the command buttons and comes up with a message saying the spreadsheet is closed for new entries.But is not working for me.

I placed the Code in the ThisWorkbook module.

[Code].....

View 8 Replies View Related

Spreadsheet That Allows Users To Select Items From A Validated Data List

Mar 25, 2009

I am making a spreadsheet that allows users to select items from a validated data list. Each item in the list has a numeric value in an adjacent column. When the user is entering data they will select from a drop down of the data list in column "A" and I would like to have the numeric value that corresponds with their selection to then autofill in column "B". I have tried VLOOKUP and IF formulas but cannot seem to get anything to work.

View 9 Replies View Related

Using Workbook By More Than One Users At Same Time

Jan 8, 2012

can we use excel workbook by many users at same time ?.

View 3 Replies View Related

Use Of On Time To Kick Inactive Users

Apr 16, 2014

I use the 'on time' function to kick users out of a shared workbook after 30 minutes of inactivity (i.e. no cells updated). Technically it works, as it does kick out the users.

However the time after which it does so seems to bear no relation to the time I have instructed. Sometimes shorter, sometimes longer! If it is was always longer, I would be happy that there is an error in my code somewhere (i.e. the time value is resetting on an unexpected event that I need to find and alter).

View 6 Replies View Related

Select Data From Spreadsheet Column If Condition In 2nd Spreadsheet At Same Time Is Met

Aug 11, 2013

I have two spreadsheets, one gives me the beginning and end of civil twilight as a measure of day vs. night. The spreadsheet has Date/Time in the first column, and the value 45 in the 2nd column when it is night. The second spreadsheet has also 2 columns with date/time and body temperatures of a squirrel. I want to get basic statistics (mean and standard deviation) of the squirrel's nocturnal body temperature, that is for times when it is night (value 45). The tricky part is that Date/Time of both spreadsheets are different. The procedure has to recognize that the date/time of body temperature lies between the beginning and end of the value 45 blocks of the first spreadsheet.

files: twilight sheet squirrel temperature

View 6 Replies View Related

Stop Users Changing Computers Time/Date

Aug 31, 2006

I am creating time sheet application , obviously i need to store the time when the user logs & logs out .. The issue is, the user can "Cheat" by changing the system time ...

Any alternatives?? Is it possible to store the time from a particular server etc or some other source.

View 9 Replies View Related

Data Validation Dropdown Menu But At Same Time Allowing Users To Enter Free Text

Nov 15, 2010

Is there a way to have a data validation drop down menu but at the same time allowing users to enter free text as well.

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

Save Macro For Multiple Users

Apr 6, 2009

When saving a file, you get a popup with a suggested path. I need to find a macro that will either offer a suggested file name based on a cell's date value (a1) and a suggested path (to the desktop) for any user that uses the spreadsheet - or simply will save the file using the cell value as the name to the user's desktop.

Each user will have their own version of the file, to save to their own desktop. The macro will need to overcome the issues that each user's path to their desktop will be unique since each will have logged in to the window's session with their own profile.

View 5 Replies View Related

Multiple Users & Accounts Sheets

Jan 22, 2010

I’ve thought up a workbook with four sheets named “Employees Summary”, “EMP001”, “EMP002”, “EMP003” and a number of customer account sheets. Customer account sheets are named by their account numbers.

Now for the hard part. I will have three employees. All of us will have to login to the workbook with a username and password. Usernames would be. Administrator, EMP001, EMP002, EMP003. You should be able to change your password at any time.

All sheets will be visible to the administrator. Employees will only be able to see their respective “EMP” sheet and "Employee Summary" sheet. the rest is hidden. And the really hard part Every employee will enter all their transactions for the day into their respective sheets....

View 2 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

Error Log On Network For Multiple Users

Mar 13, 2008

I am creating an error log as a text file for my application. Since it is being used by many different users, I decided to keep it logged in a specific folder (that is protected) on our network.

I have tested the code and it works, even if I have the log file open when I run the module, it still writes to the log file and saves (as long as I don't save the opened log file after the module runs)

What I am worried about is when 2 or more users are trying to write to the log file at the same time. I wanted to add something that checks if the file is open, and if it is, wait a second or two and then try to write to it again. Maybe try it a few times?

Below is my sample code.
Note that I am using the log creation in another module.

Sub datatopass()

LogInformation Worksheets("Email"). Range("L2").Value & "|" & _
Application.UserName & "|" & _
Worksheets("Email").Range("M2").Value & "|" & _
Worksheets("Email").Range("N2").Value & "|" & _
"other things"

View 6 Replies View Related

Share With Multiple Users Allowing Macros

Oct 9, 2008

I have a workbook that I would like to share and allow multiple users to add and make changes at the same time. However, the workbook is full of macros that really need to run. Is this possible? The workbook is written in excel 2003.

If this is not possible then is it possible to share the workbook in a similar fashion but not allow any other users to make changes, but update their workbook with the changes that I make?

View 2 Replies View Related

Multiple Users Updating Same Sheet Simultaneously?

Jul 17, 2013

I have a workbook with a list of drawing numbers (with customer, date, author etc.). New drawing numbers and their associated row of information are entered onto the sheet...

..HOWEVER, multiple users can be at least viewing and potentially entering information simultaneously.

I have written code where multiple people can view the same read only file, but not edit it and it be updated.

It seems quite unlikely, but is there anyway of 'live' updating a workbook whilst multiple people are viewing it? Or at least notifying other users when the sheet has been updated?

View 2 Replies View Related

Multiple Users With Passwords And Admin Can View All Of Them

May 28, 2014

The problem - there are multiple users, each one has its own excel file, but it has to be password protected. I assume there is a simple VBA script or something. I found something here - User name and password to open excel file . I guess I don't need it to be that complicated. I haven't gotten it to work yet, so I can't tell if it's what I need.

Also there is an Admin or whatever that has to view all of the users excel files in one excel file. Is this even possible?

View 1 Replies View Related

Allowing Users To View Multiple Sheets Once Signed In?

Feb 24, 2014

What i am trying to do: Create a login option to filter what worksheets each user can see. I need the users to be able to view 2 sheets not just 1. Also i need an admin login that can view all sheets. I want to keep the workbook protected so even though they can see and edit those two sheets they can only edit certain unlocked cells. Admin should be able to view/edit all cells on all sheets.

Below is my code which is made for a sample workbook. I was just trying to get the concept down and then i would convert it to the real workbook.

Form Code:

[Code].....

View 2 Replies View Related

Compile Data From Multiple Users Based On Criteria

Aug 18, 2011

I have a few people all entering in data into excel, since they cannot be all in one sheet they each have their own copy. I would like to be able to extract all data where column P reads "Red" from each users spreadsheet and then delete the corresponding lines from their spreadsheet (end of day activity)

The Sheets will be named
FDEntryU1AM.xlsm
FDEntryU2AM.xlsm
FDEntryU3AM.xlsm
FDEntryU4AM.xlsm

[Code] .......

I will then need to do the same in another workbook for all items Labeled Blue, but that of course will be same code with just an item replaced.

The idea is after they close up the person overseeing the data can import all at once and leave the users with fresh empty workbooks.

View 9 Replies View Related

Sharing Workbook With Multiple Users Entering Data Simultaneously

Feb 2, 2013

My Workbook contains several UserForms in which employees will be entering hours and activities on a daily basis. In the UserForm, they select their department and enter hours for each specific type of work/activity that shows up for that department in the userform. They click the submit button and all the data (date, name, department, type of work and hours) is added to a database table in another sheet, which in turn feeds a number of reports.

I need to be able to have anywhere from 20 to 100+ employees enter their hours on a daily basis, many of them at the same time, all from different locations (within the network of the client's system), using the same UserForms.

We've experimented with Google Drive, but that seems not to be the solution. It kind of works, but is not secure (it installs a copy of the entire workbook on the users system and then synchs the data back to the server upon "save") and way too cumbersome. I've heard of SharePoint, but not every client has that installed (and frankly I don't know how it works).

View 3 Replies View Related

Create Master File With Macro Built In That Will Allow Multiple Users To Use It At Once

Feb 7, 2014

I am trying to create a master file, with a macro built in, that will allow multiple users to use it at once. The macro is to open a dilouge(sp sorry) box showing the contents of a specific folder, allow the user to selct one of the sheets, then copy and paste the set details from the hidden tab on this sheet (All sheets will be the same barring title), append the details to the master list in the first empty row.

I've got this far thus
Sub Macro1()
'
' Macro1 Macro
'
'
' Modify this folder path to point to the files you want to use.
FolderPath = "My Folder name here"

' Set the current directory to the the folder path.
ChDrive FolderPath

[Code] .....

So I can copy the row, but I can't get the first part to open .

View 3 Replies View Related







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