Visual Basic Script

[Stalker_26]

Hi all,

After recently "popping my cherry" with excel, my boss has decided to task me with the following.

I already have a spreadsheet with IF, V/Hlookups etc, now i need to produce a script/code or whatever it is called, where on any given spreadsheet, any changes to the data, or any new additions to the sheet, excel will auto save a log of what user log in, date and time the change was made, and possibly show what the data was before it was changed.
But it needs to be a log that can only be viewed and not edited.

It also needs to run on a shared HDD so anyone in my dept can view it, i assume that means it will only allow one person at a time to edit the sheet, but i am not sure.
I am aware that a sheet can be password protected, but i have been asked to provide a system that will not allow any changes by anyone without a time, date and user ID stamp.

Any help would be great as i am shortly going to run out of hair to pull out

 

[Stalker_26]

Sounds like a good old romp then, best get to tesco for some red bull!!!

yes it is an excel spreadsheet, a few different ones, but excel none the less.
Now, next question, what the heck is VBA, how does one use it, and where do i find it, n most important, what will it cost to get it and use it?

And yes, the data will be changed on an hourly/daily basis, and at the end of the day collated onto a master sheet to show efficiency, targets, hours, blah blah blah (all the fun stuff)

It will ultimately be, a shared workbook, on our shared network drive, all can access, but no-one may edit without leaving a log of who and when.

Im a hardcore gamer (cod4 + too many beers to count) at the weekends so long spells in front of my PC is no problem.