Solved: Create History

[kathyb0527]

Is it possible to create a history, without sharing, that stays with the excel file as it's own worksheet? There is a post named "Create History without Sharing" that uses html, but it creates a separate file.

Any help would be greatly appreciated.

Kathyb

[Bob Phillips]

It is possible, but you would have to hand-craft it all yourself. For that you need clear rules as to what history is to be saved. Not trivial I fear.

[Benzadeus]

Well, I have a workbook that registers the users that accessed or modified the workbooks, saved in a spreadsheet. Want?

[kathyb0527]

XLD,
That's what I thought you'd say. I just wanted to make sure before I let my "superiors" know.

Benzadeus,
Sure! Maybe I can get some of the info that management wants.

Thanks!

Kathyb

[Kenneth Hobs]

Depends on what you want but maybe something like: http://www.mrexcel.com/forum/showthread.php?p=1666961

[Benzadeus]

Here's the workbook
*Sorry, but I don't know the original author.