shared workbook

  1. 7

    Shared Workbooks with VBA

    Hi, i have developed the following architecture to manage and report on the bidding process: - a workbook that generates quotes in a CPQ format, deployed on the salespersons local machine - after the bids are finalized the salesperson automatically uploads the quote in a centrally hosted...
  2. K

    row highlight code doesnt work in Shared WorkBook

    Dear All, Following code is to highlight the Row in the given range when a cell is selected. This codes works perfectly alright until the time the workbook is Shared. "Application defined or Object defined error" is shown when the workbook is Shared. Private Sub Worksheet_SelectionChange(ByVal...
  3. K

    Protect SharedWorkbook

    Dear All, I have a workbook which has to be shared between 3 to 4 people, who will update data at the same time. but depending on the user opening the file, certain sheets to be hidden and visible. How do i achieve the same. Kindly suggest. Regards Krishnamoorthy S
  4. J

    Change from Shared Workbook to Coauthoring

    Hi, I have created a client manager in excel 2013 at work which uses the shared workbook feature. I need to use drop down lists so all the data validation needs to be set up before i share the workbook. If we make any mistakes we have to unshare the workbook, copy and paste the 'data validation...
  5. C

    Restriction to users in specific sheets in a shared workbook

    Hi, I have a shared workbook where there will be many users working together simultaneously. Lets say users are "A", "B", "C", "D" and so on. I want to code the file such that user A can only access the spreadsheet that is to be worked by him and other users should not have edit/delete access...
  6. E

    Shared Workbook issues and error messages

    Office 2010, Windows 10, An Excel Shared workbook being used by 12 Users stored in a shared folder on the network server. The issue is when a user tries to save the workbook after making their changes, they get the following error message. Then they have to close the file and lose their...
  7. J

    Excel VBA message box for multi-user updates

    Hi, I have a shared workbook with the option of autosave and update set to every 5 minutes. I would like that after an auto update and save if a user modified a specific cell a message box will appear. I have already tried Worksheet_Change(ByVal Target As Range) and Worksheet_Calculate()...
  8. N

    VBA User Form in a shared workbook

    Hello, I have searched high and low but to no avail. Please can anyone help...? :confused::confused::confused: I have built a user form in excel, which I need to be updated by multiple users, so I have shared the workbook. Upon clicking 'Save' the date is transferred to the next available line...
  9. V

    Shared workbook - but users see different information!

    We have been using a shared workbook with various tabs (excel 2010 - now 2013) for about 6 months now without any issues. However, 1 of the 6 users reported today that when she opens the shared workbook, she now can only see data from 2 months ago - not the most recent version (even though she...
  10. J

    Run user form in Shared Workbook

    Hi all Is there a way to run a user form in a shared Workbook??
  11. J

    Activate Macro/vba for a shared workbook

    Hi All Is there any way to keep your Macro's (VBA) enabled on a shared workbook???<strike></strike>:confused:
  12. S

    Running VBA macros in a shared document

    I have an excel workbook which has several VBA forms with macros running to handle the information inserted by the user. Everything runs well until I define the workbook as shared, allowing others to make changes to it. Once defined, one of the forms aborts with the following error: 'Run time...
  13. D

    VBA to save shared workbook any time a cell is modified ?

    I am completely new to VBA, but from what I know it seems this should be possible. Could anyone please walk me through how (and where) to enter a VBA that will automatically save the shared workbook any time any user changes any cell. The practical application is that I have a PO log that...
  14. C

    Does Shared Workbook feature work when file is managed through SharePoint ?

    Dear All, From the web link : https://support.office.com/en-nz/article/Use-a-shared-workbook-to-collaborate-b8207fe9-a613-483f-b804-0ca4658b0c61 I have understood that the SHARED WORKBOOK feature in Excel, allows multiple user to read and write on a single EXCEL Workbook kept on a common...
  15. E

    Any way to force-close a shared workbook without writing to file?

    Hello fellow Excel guys, I'm a developer for my company, and we use a shared workbook which is accessed by several people through the day. It relies heavily on VBA (so much so that I have separated out the code into an .xlam add-in which is referenced from the main file, in order to keep the...
  16. M

    Can't delete excel file "because the file is open in another program"

    Hello, I'm having a huge problem with a shared workbook that is being used by a few people at my office. I created a template which is used to SaveAs a new workbook each day. This workbook is shared and was working fine up until a week ago. Now every time a second user tries to open the...
  17. Alan_P

    Shared Workbook - Auto close when idle too long, still showing as open?

    Hi All, I'm wondering if someone can help, I have a shared workbook that I've added the below code to so that it automatically saves and closes if someone has it open for 30 minutes and hasn't used it (it was constantly annoying people leaving it open all the time!!) :banghead: It works...
  18. T

    Locking/Unlocking Sheets for a Shared Workbook while its Shared

    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...
  19. T

    Prevent turning on workbook Sharing

    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...
  20. S

    Unprotect workbook, allow repeat password

    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"...

Some videos you may like

This Week's Hot Topics

Top