shared workbook

Hello Everyone, I am trying to setup a shared workbook where each user of the shared workbook will have their own worksheet which they can lock and unlock without unsharing the workbook. Is there anyway to do this in Excel. I need the workbook to be shared so that multiple users can have access...

Hi there. I am running into problems with users Sharing workbooks that rely on a lot of VBA. It doesn't matter how many times I tell them not to they still keep doing it and then complaining when the buttons don't work. Does anyone know if there any way to either: 1) When they click the share...

In one of my macros, I unprotect a shared workbook. I haven't programmed the password into the code. I admit, mainly because I was having problems with it, and decided that entering it manually wasn't such huge deal LOL. The line of code I'm using is simple "ActiveWorkbook.UnprotectSharing"...

Hi, I've read the previous posts however none have really been able to fix the problem I'm having. I have a shared spreadsheet that colleagues use daily (MAILBOX LOG), however I want a master spreadsheet that will pull data from each worksheet withing the MAILBOX LOG worksheet. The current...

Here's the situation: I've got an XLSM workbook in a shared network folder which is a trusted location. It's a shared workbook used by up to 7 different users at any given time; Office versions include 2007, 2010, and 2013. The workbook is slow to open, save, close, and run the macro...

Good afternoon all- I've been scouring the board for a solution to no avail. You all have been extremely helpful in the past so I figured I'd post a new thread with as much details as possible. The consensus seems to be that arrays cannot be shared...so I'm looking for a workaround and...

Hi, I have a UserForm setup that submits information to an email and then saves a log of all information to a back sheet of the shared workbook. The issue I am having is that if 2 or more users have the sheet open at once it will only log 1 users submission in the back sheet (it come up with...

I am building a workbook for several users to enter data. There are a number of fields for each record, and the users may not know there is a conflicting save point (created by another user) until after they've spent a decent amount of time in the workbook. Is it possible to have a VBA code...

Hi everyone, I had an excel file that is shared over the network and only two people can access it. So every changes made from that file will automatically update and everytime each user will open the file, they should see same design, and data. Computer A is using Office 2007 and Computer B...

What is an easy method to protect a worksheet in a shared workbook. The workbook needs to be shared so multilple people can update their weekly numbers (several columns, cells need to be updated weekly by multiple people) The worksheet needs to be protected somehow because people are somehow...

I have an interesting problem that I've not come across before when using Excel 2010. I've created a spreadsheet at work that has two summary tabs which contain hyperlinks to around 30 separate sheet tabs. On each sheet tab there is a list of unique values in column A (and other information...

Hello All, I am having an issue with a macro abd sharing a workbook. The macro enables me to using grouping while protecting the worksheet. Here is the code: Private Sub Workbook_Open() Dim wksht As Worksheet For Each wksht In ThisWorkbook.Sheets With wksht .EnableOutlining = True .Protect...

I have a requirement to transfer data from one application to another that necessarily involves a number of different data mappings. To complicate matters, the target application contains various distinct workbooks (managed by different users), with each source "line" of information being...

Hi, i've just started a new job today and i introduced shared workbooks to the office but I have a problem which has caused me to have some egg on my face.. (:S) I have a shared workbook on a network and when there is a conflict, Excel doesn't ask my permission. The shared workbook settings...

Hi. We have a shared workbook (version 2003) on a shared drive that sometimes has up to 10 people accessing it at the same time. I have set the frames on all the worksheets to B9 and saved the file. The first person to open the file has frames. Subsequent (simultaneous) users do not...

Hi, I'm trying to enable outlining in VBA so I can group rows together, but also have the sheet protected so functions are proctected from deletion. The kicker is that the sheet also needs to be a "shared workbook", which inhibits protecting the sheet. I have the code below that works until...

I am using Excel 2010 on a Windows 7 Pro OS. I have developed a simple weekly schedule spreadsheet for use by our project managers to help allocate junior engineering resources. There are two different divisions within the company and I have simple macro buttons that will hide/show the...

Question from someone in my office -I have no experience with Shared workbooks... 5 users (user 1 thru 5) open a shared workbook at the same time. Each user works on a different tab (Tab A thru E). User 1 finishes their changes on Tab A first so saves it. The auto-recalc before save calcs only...

Hello, I have an excel workbook that grabs data from another workbook. I run a family business and my wife and daughter need access to the file too. So the workbook is shared. The problem I am having is excel is changing the path inside cells, and thus making them not work properly. Here is...

Hello, I've looked through many posts but I don't think I can find any for my problem (sorry if I'm wrong). I have a shared workbook that many people will be using (and probably at the same time). I have a few macros in the book that, when run, unshare the book, unprotect the particular sheet...