VB MACRO IN SHARED WORKBOOK(EXCEL)

VB MACRO IN SHARED WORKBOOK(EXCEL)

• kushpaw

  Hi,

  I read the details you have put on the site and a few criteria’s do match to same query, but will put my case in detail below:-

  I have two excel sheets named "Input" and "backup". The "Input" sheet is an interface and the user has read-only access to it. All the VBA coding has been done in the “Input" sheet and the user will input data on various sheets and click on the save button. This button executes a code to open the password protected "Backup.xls" file which is a mirror copy of the Input sheet and will copy the data from the "input" file to the "Backup" file, save the "backup" file and the complete application is closed. The code works fine without errors.

  Now I place the files in a shared network and for the backup file click and activate the "Shareworkbook" option, if now multiple users access the "Input" file and click on save button, it gives me an error saying that the "Backup file is read-only and cannot be accessed at this time".

  Please could you help as to how we can sort this or if this is not possible and there is an error, how we can close the backup file so that the user is not able to view the file, as after the error the "Backup" file is open

  Regards,

  abbs.

  
  
  

• drweaver

  Hi,

  You cannot share a workbook, well you can but only one user will have write access to the data. If it's just code/forms your looking to share so that more than one user can run the code against their own set of data then your looking to create an addin (xla file).

  To share the addin you need to place it on a network share. There is an option in Excel, I believe it prompts you, when installing an addin to specify whether the addin should be copied to the local machine or kept in the share, if you keep the addin on the share then all users share the code and any changes to the addin are reflected for all users using it.

  I hope that helps.

  
  
  

• spshah

  ChassAA ~

  I'm working to set up a resource library that utilizes macros to take a user through menu options. This resource library needs to be accessible as a shared workbook so that more than 1 user can be in it at a time. Please advise the best way to protect and share the workbook but still maintain the various vb macros.

  Description of set-up:

  There are multiple tabs within the workbook but only one tab displays at a time depending on the menu selection. It is set up to run with a topics menu, category menu for each topic, resource menu for each category, and a file menu for each resource.

  Step through example: The main topics menu currently has 4 options. If you select training from the combo box, the topics menu is hidden and the "Category - Training" tab is displayed. On the "Category- Training" tab you again select from the combo box - processes, this hides the "Category - Training" tab and displays the "Resource - Curriculum Descriptions" tab. The "Resource - Curriculum Descriptions" tab has a hyperlink to the file on the network for each class.

  Thanks ~

  
  

• Christoph Hornung

  Please elaborate on what you wish to do, be specific

  ChasAA

  
  
• VB MACRO IN SHARED WORKBOOK(EXCEL)