shared

Hi all, I have an Access 2010 database that is on a shared drive so many people use it, and i want to password protect it so only those with a password can get into the actual file (in case we need to make updates to it.) I'm able to put password protection on the file, but the problem is that...

I have a conundrum which I'm hoping someone here will be able to help me with. I want to be able to dynamically change an autofilter on a protected sheet in a shared workbook. The problems I have are: * Shared workbooks do not allow sheets to be unprotected and then re-protected: therefore the...

I have made an automated macro file that runs a hold queue every 15 minutes. Now we are looking into the possibility for multiple locations being able to add notes for the lookup without all locations having to run the macro. I have experience with shared files and the issue is there is only...

Hello all! I have a workbook that users will be downloading/exporting from an external source. Once downloaded, I have two hotkeys that run two macros. I would like the location of the macro to be saved on the shared drive, so when a user hits the hotkeys, excel will still know to look for the...

We have a relatively large spreadsheet. At ant time there may be up to 4 people updating parts of it. It contains no formulas, but they do use the freeze frame function and some use the filtering tool. Many issues, freezing, lost data, error messages. It has been re built two or three times so...

Hi all, Again I am in need of the communities vast experience and knowledge. I am trying to create a multi user secure log sheet. The whole goal is to create a logging system for call logging at work. Currently what I have is that everyone uses there own workbook and fills out everything and...

I designed a small application that provides charts to be reviewed by 6-10 other users over the internet. The data is updated by me and the charts are generated by me after each update. I want the users to be able to read the charts but not to see the macros. Since there are 24 charts, I have to...

(Using Excel 2010 & Windows 7) Need to link the separate name of each of four sales reps that are in a drop down menu in Excel 2010 to their individual folders on a Data (E:) shared drive (The Sales Rep's individual folders contain the counties assigned to each of them and they need to have...

Hi, I've set up a sharing workbook but have a problem with permission. I want it to effectively 'lock' the input for users after they 'submit' their data. The specific user cells have been made accessible using Allow Edit Ranges in protected worksheets. Accordingly I'm wondering if there's...

Hi! I need a macro to check if .xlsx files in a specific directory are shared, as we have need them always shared, but the users forget them to share after some editing. It will be very cool of the macro could make the unshared files shared, but this should be hard work. The most important...

Hi everyone I need to remove a a faulty drop down validation from a Excel 2003 sheet which has track changes activated (i.e. is shared). The usual way, turning off the shared workbook settings, doesn't work, because I need to keep my change history. Is there another way I can do this, maybe...

I have an Excel workbook that uses a macro to generate approximately twenty different worksheets. Each worksheet has hidden columns (with a heading on each column); the data is sorted, frozen at a particular row & column and is also filtered. The page settings are also changed to legal...

Excel 07. We have a workbook with multiple sheets which we are encountering a problem with. The workbook itself is actually in the small to medium size range, having 5 worksheets. It is a shared workbook and is accessible to many people. The problem we are encountering seems to be related to...

Excel 07. We have a workbook with multiple sheets which we are encountering a problem with. The workbook itself is actually in the small to medium size range, having 5 worksheets. It is a shared workbook and is accessible to many people. The problem we are encountering seems to be related to...

Greetings. I have a workbook that was developed in Excel 97-2003 that is shared and password-protected. It opens up fine in 2007, but is having issues in 2010: The first time I opened it, I had to enter the password twice. It then opened in "Protected" mode. I clicked "Edit Anyway". I then had...

I just upgraded to Excel 2010 and noticed the following immediately. When I place an ActiveX control (e.g. a command button) on the worksheet, and then share the workbook, the button does not work any longer (as if it never gets pressed). The control works fine in the un-shared workbook. I do...

Just because I think in an office environment this kind of thing is really crafty and cool. based on a simple naming convention, you can dynamically move around macros within your company. Example: 1.Setup (under the Baddress\role macros) folders called 'TIM1' 'BOB2' & 'ALEX' 2.Name your...

Hello, Living in a house with 7 people has many perks, but working out a completely fair kitty system is not one of them. We all cook for each other about once a week. We note down who paid for the food, how much it cost and who was present out of the 7 people living here. We have all tried...

Hello, I have a spreadsheeet that's used as a sign-up sheet. The goal is for a user to be able to enter data (their name) into a cell, then lock it to prevent another user from making changes to that same cell. My code works perfectly until I share the workbook. When it's shared, it seems to...

Greetings all, I have a group of users who have a shared workbook on a network drive and they have recently started experiencing issues opening the workbook. The scenario is as follows: roughly 15 users, not all of them have issues happens on both 03 and 07 with latest SPs OS is XP Pro SP3...