Timestamp Doesn't Work When Workbook Is Shared

Can you post an actual example??


Just FYI,

One logical bug I've made myself with worksheet change is the "what if the change covers more than one cell?" kind of error. For instance, you code will probably work if the user selects one cell and makes a change.

But what if they select a bunch of cells and press delete (for instance). If the "Target" passed in is a range of cells then "Target.column" or "Target.Row" will no longer work.

Is there any change the worksheet protection is to blame? I notice you have a line to protect, but no line at the beginning to un-protect the sheet prior to writing in the third column.

Here is the spreadsheet I am using;

\1

When I enter something in Column A or B it gives me this Error, all other cells I have locked for editing.

I think I might have to add an extra line of code to it so it allows the Macro to run when Shared, I don't know though.

Thankyou;

Anaky

Sorry, when asking for an example, I meant a spreadsheet and not a picture of one Also, please use the upload file option that is available when you press "Go Advanced" instead of linking to another location.

BTW, if the error is happening when you enter a value into a single cell in column A - then there must be something wrong with the .protect() part (because the IF would be bypassed as the target.column would evaluate to 1).


Why do you need to protect via a macro, when the macro did not unlock anything? Seems strange - I would suggest removing that line

Ok, I have a few suggestions.

First, the code needed to have some alterations to handle changes to lots of rows at once. Instead of just checking for the "Target" column, find the intersection of "Target" and Column B. This is more precisely what you want to do (I think).

Also, don't hard-code values! I used some named constants at the top of the module (where they will always be easy to find) to allow for easy editing. This is a good habit to get into.

When you use a worksheet change event (that causes another change to be made) turn off events! Otherwise it will want to run again... it's just sloppy. You can turn the events back on prior to End Sub.

Also, the way your sheet was set up people could alter the tab names - like "Days B". To avoid having that mess up your code, use code names which you can only alter in the VBA editor (you'll see what i mean if you view the object explorer on this workbook).

:D

Please have a look at the attachment.


CODE FOR CHANGE EVENT (I put this in "Days B" - try it out):

Please Login or Register  to view this content.

I'm not sure what to tell you. You mean, when you open the workbook it does what it's meant to and when someone else does it gives a 'stack overflow' error?

Are they opening the file from another computer, or logged in as a different user, or over the network? Not sure what you mean by "share the workbook".

you can't change the protection in a shared workbook

If that is the case I suggest you figure out a different way to "share" the workbook.