Tracking Changes Without Sharing The Workbook.

Jun 21, 2006

I have a workbook which has a database and a pivot table. I wish to track changes without sharing the work book.

Is that possible?

Also how can I keep track of the users accessed to the workbook ?

View 3 Replies


ADVERTISEMENT

Sharing Workbook And Make Changes On Excel Workbook At Same Time

Jan 23, 2012

Any way that two or more people can share and make changes on a excel workbook at the same time.

View 1 Replies View Related

Sharing One Workbook With Multiusers

Sep 17, 2006

I build a workbook with 7 users and each user has his own password and this workbook putted in our server drive ( Common Drive ) and each user has the ability to make any thing in his own sheet

So How could make this workbook shared with this 7 users using VBA Code?

View 9 Replies View Related

Sharing A Workbook Dependent On Sources

Aug 12, 2007

I have a workbook which relies on another "source" workbook for getting some data. It then does some processing on the data and displays some results.

I want to share the workbook with the results with others, but I don't want to give them the "source" workbook.

View 9 Replies View Related

Excel 2010 :: Sharing Workbook Corrupts File

Nov 15, 2011

We have an Excel file that 20+ Users update daily. Every time we share the workbook, it corrupts the file within days.

We are using Excel 2010. We go to Review tab, Share Workbook, and check the Allow Changes box.

View 2 Replies View Related

Sharing Workbook With Multiple Users Entering Data Simultaneously

Feb 2, 2013

My Workbook contains several UserForms in which employees will be entering hours and activities on a daily basis. In the UserForm, they select their department and enter hours for each specific type of work/activity that shows up for that department in the userform. They click the submit button and all the data (date, name, department, type of work and hours) is added to a database table in another sheet, which in turn feeds a number of reports.

I need to be able to have anywhere from 20 to 100+ employees enter their hours on a daily basis, many of them at the same time, all from different locations (within the network of the client's system), using the same UserForms.

We've experimented with Google Drive, but that seems not to be the solution. It kind of works, but is not secure (it installs a copy of the entire workbook on the users system and then synchs the data back to the server upon "save") and way too cumbersome. I've heard of SharePoint, but not every client has that installed (and frankly I don't know how it works).

View 3 Replies View Related

Sharing Workbooks; Copy And Paste The Workbook Onto Another Laptop, None Of The Scripts Work

Jan 31, 2007

I have created a workbook with vb code that include 4 modules, 1 userform. These all work in the original workbook. When I copy and paste the workbook onto another laptop, none of the scripts work? Both laptops run the same os plus office 2003.

View 2 Replies View Related

Tracking Changes To A Log Across Workbook

May 28, 2013

I am looking to track changes on a "Log" sheet throughout an entire workbook. The following code (found here and given below) will give me:

The cell . The date/time it was changed . What the new content in that cell is

The two points I would like it to include, in order of importance, is: The name of the worksheet that cell exists in. The user that made that change*Bonus points* a hyperlink that'll bring me to the worksheet that was edited.

VB:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim r As Long, OutSht As Worksheet
Application.EnableEvents = False
Set OutSht = Sheets("Log")

[Code] ......

View 7 Replies View Related

Tracking Changes In Workbook

Jun 28, 2006

I'd like to make a vba macro in excel which will be just like "Track changes" feature. I'd like to track changed cells and when and who did it. (Date, User, Cell, Last value, New value). It is important to make a report in separate worksheet and automatically fill this worksheet when the user save changes.

View 5 Replies View Related

Sharing Add-in

May 5, 2009

I am having trouble sharing an Excel Add-in I've created which contains three macros (modules). I have looked everywhere but, oddly, I can't seem to find a definitive answer. I would like for people to be able to install the add-in, and have access to three macros which it contains.

What is the best solution to this problem? I would like to add buttons to the add-in ribbon that execute each macro individually. The macros should be available to all workbooks once the add-in is installed.

View 9 Replies View Related

Sharing The Value Of Job Over A Certain Period

Nov 13, 2008

i need to share the valve of the job over the months. see attahed excel sheet. say the job worth 10k has a start date of the 30th of nov and the end date is the 1st of dec. the value of the job is shared between two days and then put into the relevent cell. as regards to the months they are not calander months so the start date and end date of the months are diffrent see attached sheet for full details.

View 2 Replies View Related

Sharing Same Value Between Several Sheets?

May 14, 2013

I have 3 sheets in the same workbook. how could I have all three sheets share the same value if I edit one sheet or the other? Right now I have to edit sheet 2 to get the same value on sheets 1&3. I would like to know how to edit sheet3 to be same as sheet 1&2 vice versa.

View 4 Replies View Related

Limit Use & Sharing

Dec 27, 2007

I've spent a fair amount of time creating a financial planning spreadsheet that I'd like to try to sell. My biggest problem is selling it to people and allowing them to use it without them being able to email it to anyone else. My first thought was to code it where a macro will run when the spreadsheet opens that checks if the spreadsheet is being opened on a specific computer and will close down if it is opened on an unauthorized computer. I'm not sure if this will work or how to code it

View 2 Replies View Related

Sharing Excel File Over Network

Oct 22, 2003

Sharing excel file over network for use by multiple persons. File has suddenly stopped opening giving message "File cannot be found" etc.... I back the file up daily to my hard drive so didn't lose much.

This is the second time this has happened. File size is only 300Kb.

Excel seems to be creating temp files to the same folder, then gave a message saying changes could not be saved to the excel file.

Ran the corruption program from this site, it could not open the file.

View 2 Replies View Related

Sharing Add-in With Password-protected Code?

Apr 10, 2013

I have an add-in which I want to share with others, but I want to protect the code from modification.

I know how to apply a password to a VBA project (Tools -> Project Properties -> Protection) but the problem is this: when a colleague installs the add-in, the subroutines within the add-in are not available in the Macros list to be added to the ribbon (in the Customize Ribbon window). The subroutines only appear when I remove the password.

View 1 Replies View Related

Sharing Custom Menus & Their Macros

Aug 26, 2008

Our ERP system generates reports in CSV. I have created a custom excel menu, which houses a lot of buttons that launch various macros to format these reports. I have been asked to share these formatting macros with other users.

I understand that the custom menu structures are stored in an excel11.xlb file. My thought was to simply replace the users *.xlb file. This only half worked. I get the menus and the macros, but when the users try to run the macros from the menu excel can't find them because the path is pointing to my user name.

View 3 Replies View Related

Sheets/Worksbooks Online For Sharing

Oct 16, 2006

We want to share an excel sheet online, where we can go to and edit and save it. And possibly link the fields to a dB to build a website from. Anyways what is the best cheapest way of doing this? I googled and found so much stuff, was hoping someone here has already gone thru this process and can just point me to the best one....

View 2 Replies View Related

Run Error 1004 When Sharing Book

Apr 26, 2007

However, since I have shared the document the macros do not work. I am a little confused at this as I thought there would only be a problem if I protected the document, so I took that off yet I get a run error 1004. I have played with the code to have exclusive access but that doesnt appear to make a difference either.

Sub GetDataFromClosedWorkbook()
Dim wb As Workbook
Dim CurrentSheet As String
CurrentSheet = Application.ActiveSheet. Name
' turn off the screen updating
Application. ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
' open the source workbook, read only
Set wb = Workbooks.Open("L:Clearance&AgencyCollateral Management ProductsCMSGRQV SPREADSHEETSRQV.MasterSheet.xls", True, True)...............

View 3 Replies View Related

Sharing Class Module Among Multiple Userforms?

Apr 22, 2014

I have two user forms, each with a checkbox for Jan-Dec. Also, I have a checkbox "All" to check/uncheck the Jan-Dec boxes. I also created a class module so that if any of the Jan-Dec boxes get unchecked, while the "All" box is still checked, it will uncheck the All box. Basically I just don't want the All checkbox to be able to be checked while any single month is unchecked. The only/easiest way I found to do this was with a class module, so I would not need to create individual Checkbox_Jan_Click() events for each month.

Now my issue is, I have 2 userforms like this. I'd like them to share the same class module, but in the class module I need to refer to UserForm1.CheckBox_All. So I need to dynamically refer to whichever userform was active, but as far as I can tell, this is not possible.

View 4 Replies View Related

Sum Of Multiple Ranges Sharing A Single Criteria

Jan 19, 2010

IM trying to add the result of multiple ranges sharing a single criteria and have had no luck. I am trying to get the range from every other colum and have the total qty of the selected criteria display in a single cell. The best way to describe is countif with multiple ranges and a single criteria. perhaps countif isnt the answer, it is the only way i know to describe the issue though.

View 3 Replies View Related

Sharing Workbooks With Macros Built In The File

Jan 15, 2014

Is there a way I can share the workbooks with macros built in the excel file?

View 1 Replies View Related

Sharing Variables In Multiple User Forms

Mar 19, 2007

In VBA i have 3 userforms, the first 2 take the data and store them in variables. The 3rd form is supposed to take the variables from the other two forms and do some calculations with them. Although i cant get the 3rd form to take the stored variables from the other two forms. Is there a way to use stored values from other userforms?

View 3 Replies View Related

Excel 2010 :: File Sharing - Link 4 Spreadsheets Where Information Will Be Updated By One Person

Apr 21, 2013

I have a Excel Spread Sheet which has been created, there will be 4 people in 4 different locations who will have access to this spreadsheet and will need to update/amend it through "Dropbox", my question/problem is, how can I link the 4 spreadsheets where information will be updated by one person, but will update all 4 sheets at the same time.

Is this possible and how do I go about it?

View 4 Replies View Related

Inventory Tracking

Feb 12, 2007

I have a worksheet that has multiple units listed on it. Each unit has a materials used list with quantities. I want to reference this column to another sheet and get a total materials needed list and also reference it to my inventory and subtract that number from my materials on hand. how can I do this?

View 6 Replies View Related

Inventory Tracking ...

Jan 29, 2010

So far I was able to find solutions to all of my small problems with excel just by searching here but with this one I need help and ideas how can it be done differently.


We need to track inventory from when its taken, when it was installed and we need to know every month when inventory is counted how much do we have on hand in our truck....

View 7 Replies View Related

DDE Change Tracking

Dec 2, 2006

Aaron Blood has created an excellent DDE Change Tracking.

The file is in the download area of [url]

The macro, in the xls file, archive the data from top (a1) to the End of the worksheet.

I want invert the way to file/archive the data… copying all the cells already filled, a cell down and filing the top ( A1...) with the last DDE value (In the TracK sheets).

How can I do that?

The primary code is:

Sub Change_Tracker(Watch As String, TrackOn As String)

Dim NextCell As Range, r As Double, c As Double

With Worksheets(TrackOn)
r = .Rows.Count
Set NextCell = .Cells(r, 1).End(xlUp).Offset(1, 0)
End With

View 4 Replies View Related

Reservation Tracking

Jan 3, 2007

I manage a small motel with 6 rooms and I'm trying to write a simple program to track my customer reservations including their details. All the commercial software is too elaborate and way out of my price range. I'm slowly learning excel but this has proved beyond my capabilities.

View 9 Replies View Related

Tracking Paid Transactions

Mar 25, 2014

I want to create a spreadsheet that I can export my transactions from my credit card onto -- is there a way to make it so that the transactions that haven't been covered by my most recent payment(s) are red, while the ones that are paid are green without manually going through & doing it? I know there's the IF, TRUE, FALSE formulas, but I'm confused on how to use them.

Basically, if I spend $1,000 between 5 transactions and make a $400 payment, I want the oldest transactions totalling up to $400 to turn green, while the remaining are stay red until a new payment is posted.

View 1 Replies View Related

Change Tracking Automatically

Aug 21, 2007

I have a spreadsheet i would like to have changes tracked to automatically. I know it's only a matter of clicking a few buttons to get this to happen, but i was wondering if there is a way to have excel do this by default when i open the file. I would also like to have the changes highlighted automatically.

View 9 Replies View Related

Tracking Updates And History

Feb 5, 2014

I have an actions tracker worksheet.

I want to type status update for an action - then when I press enter it should automatically as soon as I press enter:

- cut the text I typed from the cell leaving it blank
- move to the target cell (its in the same row) and "add" that text string (with a date stamp added) to the text already in the target cell.

Every day I type an update against the action in the first cell - and I press enter - it should copy that text into the target cell.

That way I have a complete history of updates against the action with date stamps.

Sounds pretty simple but I don't know where to start.

Example of a simple worksheet attached : Tracker.xls

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved