shared

Hi, We have macros saved in a shared excel document. The majority of these macros open other docs saved in the network drive however currently the macros can only be used on my machine because of the path name i'm using. For example: ("C:\Users\HarryKane\Folders\Itscominghome.xlsx") So...

Please help! I have a workbook that has 30 tabs all are the same. I have added a button to protect each sheet and another to unprotect. This is so that when the sheet is full it is locked off so nobody can change the info. My problem is when I share it! I cannot use the buttons. Is there another...

Hi there, I have this macro that extracts data from a shared inbox. I need to set it up on another person computer who has access to a different inbox where the same mail is stored. The following code runs fine when I point it at one shared inbox, but when I point at a different one I get a...

Hi all gurus, I currently am running a P&L - Trade position excel on my bloomberg terminal. The excel file is linked to bloomberg live quotes and ticker with real time updates to the price and current P&L. The bloomberg terminal and the rest of the computers in the office are linked via a...

Is there any solution to populate all the file in shared folder using Userform Listbox?

Is there a way to allow a1=b1 and b1=a1, and allow input from a1 or b1

Hi all, I have a shared workbook, in which a certain sheet contains confidential information. I want to restrict access, if not to the entire doc, then at least to this sheet. Just after some advice if anyone has done this before :) The first problem is that I can't encrypt the whole doc...

folks, i have a macro that creates a bunch of emails and stores them ready to send in a shared email account. once reviewed by my manager, they are to be sent out. I have been trying to find a macro that will enable these emails to be sent all at once from the shared account drafts folder. Can...

Hi All, I use the below code for a few workbooks that my department uses, this unfilters the worksheets on opening. This was needed as some shared users were being annoying and saving the documents with columns filtered. Private Sub Workbook_Open() Dim sh As Variant For Each sh In...

Hi I have a shared workbook and this formula won't automatically update; ="Welcome"&" "&PROPER(LEFT(username(),FIND(" ",username())-1))&"," So I added this to calculate on open; Private Sub Workbook_Open() For Each sh In ActiveWorkbook.Worksheets sh.Calculate Next sh End Sub...

Hi I am learning how to share a workbook and track changes. Under Review there is a option called: "Protect Shared Workbook". I did not find that option is needed in anything. I can track changes without clicking on that option! not sure why is there. Thank you.

I forgot password to unprotected shared work book

Hi I have a shared work book, in 2010, which I want only allow certain users to make changes to all the sheets. What would be the best way of doing this. Thanks in Advance

Hi, I have created a shared workbook in Excel 2013 to use as a client manager at work. I have many columns with drop down menus. Sometimes mistakes happen and the data validation for the drop down is removed. This can be fixed by asking everyone to close, un-sharing, copy and paste 'data...

I have used the form control checkbox in a shared workbook. The checkbox is on an 'input' sheet. When a macro on the 'input' sheet is run, the data is then copied to the bottom of the 'record' sheet then all unlocked cells and checkboxes are cleared so the 'input' sheet can be used again. It...

I have a shared workbook with frozen frames and autofilters. You know what's coming next ... yes, other people frequently leave filters set, and that messes things up when the next person comes along, takes the filters off, and now the first umpteen rows are frozen and they can't scroll. So I...

Hi All, I'm hoping someone can offer advice. I would like to know if there are any alternatives to drop down menus for a shared workbook. Something where only a predetermined list of options can be entered into each column. The reason is that I wanted to make a database of clients and...

Morning I have put the following code into the workbook to hide the toolbars etc, and shared the workbook. As its shared the Macros are disabled. I have saved the workbook, but when I have gone to click a button on my spreadsheet which sorts it, it bring up an error. How can I unshared the...

Dear Friends In my Excel workbook I have created links to some media files with the help of Hypelink Function. The media files are on the shared folder on the server PC. The workbook is on Client PC in a shared folder. Now when I click on the link it says "Cannot open the specified file"...

Hello all, actually im from excel forum and im post this problem but no response.. my problem is i have a two excel file with a userform connect each other and i want the one excel file to use in other computer. i try share workbook and folder shared but same failed. how to use my excel in a...