shared

I want to avoid other users to hide rows in a shared Excel file. How should I proceed? Thanks.

Hello all, I have a tracker file opened with user form login and showing/hiding individual sheet for each user. This file needs to be shared. The original code is using .protect and .unprotect to execute macros and vba changes on one of the sheets, which does not run on the shared file. Getting...

Hi, All... Background: I have a LAN-based Shared workbook that occasionally becomes corrupted after users go in and change formatting and add highlights. When this happens, I need to do some manual workaround for my VBA to run the next day. The "shared" aspect is mandated by management and I...

I want to duplicate a worksheeet (Tab) within a shared workbook? When I try it the conventional way by right clicking on the tab a message pops up that says it's not allowed in a shared workbook. Thanks.

Hello all, I googled a bit and it seems like macros don't work within shared workbooks. Maybe there is a way around it or something, but this is what I need. In workbook one would be a code where in inputbox would be entered a number. That number would be searched withing shared workbook and...

I am not sure what I need is possible, but worth asking! I have shared workbook that is also has the sheet protected (no password) I have an existing macro that to run, needs to unprotect the worksheet, run, then protect again. When not shared it works fine, but cannot run when shared (due to...

Hi, I have a problem. I would like to lock my shared workbook so people wont be able to delete the added formulas, however they still need to add new rows and columns. It's a financial forecasting system. If there is a way to protect the formulas in the workbook would be a great help as...

Hi all, I am creating a file that will be shared between different users. They will be using input form and when button is clicked, it will fill in the next row with data. This all works fine, however i am having difficulties with shared enviroment. Currently the code is first doing the save...

I have an Excel file that is saved in a shared drive location and is accessed by my team members who have access the shared drive. The shared drive is always up. I want to have a VBA code in the said file which could take backup of the said file every day at 8 PM in the evening at a specific...

Hello, I have a excel file that I have multiple tabs in and I've protected the various tabs by adding a password. My manager had me place the fie on sharepoint so multiple users can access it and make updates. I updated the worksheet to be a "shared worksheet" and now I cannot unlock the...

I have created a Quote template for employees. I have several guys who regularly do quoting and they work from multiple locations. Currently I rely on them to save the quotes they create to a shared Dropbox folder for me to access. That is not working for multiple reasons, main one being...

I have been trying to set one of my company's excel documents to be tracked. I have found it, I have set it up and it works really well. Only issue is, it makes the document [Shared]. The issue with this, is that the document is on a shared drive, we have tried to have it shared before but it...

I have a shared workbook which is used by up to 10 users at a time, i need to construct a live "dashboard" on a separate tab based upon the data entered on an entry sheet tab. The dashboards will consist of statistics and charts, is this possible using pivot tables within a shared workbook or...

Hi, I've been searching for a while now how to solve my problem, but I can't find a solution. I have a shared document, altered by several people at the same time. When someone changes cell B2, I want their windowsusername displayed in cell C2. I already made the function =Username() in VBA...

There is a strange event in outlook such that if you send an email from a shared mailbox then the sent email shows up in the actual users sent folder and not the shared mailbox sent folder. So to get around this I want to save a copy of the sent email in the shared sent folder or a shared...

I have multiple shared workbooks that are each adjusted daily with updates and each of these files have a table that summaries(same headers for all) everyone assignments (this table does change as people leave the group and others are hired). Need a file (master) that summaries everyone's...

Hi All, I have a workbook which has circa 30 tabs and is accessed byapproximately 25 users simultaneously. I’m looking for come coding to remove any current filters and unhideany columns then re-protect each sheet on opening. I have the following code which is removing the filters but...

Hi Guys, I'm trying to share a pivot-table within my department & to date I've been sharing the pivottable itself via a single file webpage at a shared location. The data i'm showing is hours spent on programs by person & task. The trouble now is that we have grown both our client base & our...

I have a shared folder that contains a large spreadsheet with fields necessary for reports. I produce these reports via filter and mail merge to a word document. I'm training a new person and want them and myself to be the only ones able to update the spreadsheet. The problem is, others need to...

Hi there, I had a macro that ran a report on a protected workbook. However there is now requirement to keep the workbook shared at all times so what used to be the first part of the code which would enter the password to unlock the protection no longer works while the WB is shared. I have...