Search results

For what it's worth, here is a rough attempt at what you originally were looking for where the spreadsheet is updated after the Save button is clicked. I've based this on the following: - The Input form in access has: Staff ID (ie a unique number), First Name, Last Name, Leave Type, Leave Date...

Just curious but what happens when you have two people with the same name..?

I'd definitely take it the wrong way and slap Greta Thunberg :D

This might get you started. You'll need to put this in the Worksheet_Change of each sheet 2-5 Private Sub Worksheet_Change(ByVal Target As Range) Dim wReq_Sheet As Worksheet Dim sMat As String Dim iQty As Integer Dim sDesc As String Dim iLastRow As Integer Set wReq_Sheet =...

I think I've found the Anti-Beato...

Porcupine Tree knew

I don't think that's the case but will check when he's back from his holiday.

Yeah that's why I'm unsure if it's an excel specific problem. But I can be in the workbook in read only after I've selected 'Notify' (because it's told me that my colleague has it open for editing), and then sure enough about half an hour to an hour later I get a message saying that it's...

Not really no. The only people who use these workbooks in write mode are the two of us (not at the same time of course)

Another random problem that one of my co-workers is having is that he regularly will be working on a workbook in write mode and approx. half an hour later I'll hear him swearing and then showing me that his file has gone from write mode to read only. I've never seen this before and thankfully...

Hi Doc, yes we are all using the same versions and I also have my workbooks open with a choice between write and read-only so staff will only go into one in write mode by accident, which is no problem as we can tell who it is. We are using 365 yes. I guess what I need to do now is work out how...

That's ok I wasn't exactly sure either but what you have described is pretty much the behavior I'm seeing. What I find strange though is that there is no locking file present at all when this happens.

The workbook is pretty much 'stand-alone' and not linked with anything. I think I've pretty much narrowed it down to people who are using the file in read-only mode while I've had it in write mode. So when I close the workbook the locking file gets deleted, but for some reason there is a...

The guy I got mine off asked me if I was going to put it up myself, so I had to say "No, I was thinking maybe in the living room"

As Gasman states, your range is wrong to being with, but the syntax looks weird also. You really should end up with something like this Range("B5:C16").Sort Key1:=Range("C5"), Order1:=xlDescending, Header:=xlYes

Thanks for that Doc_Man, will look into the link and whether or not I'm even allowed to use it at work. As for the OPENFILES /Query - I got a 'ERROR: Access is denied.' which I guess means that I would have to run as an Administrator, but then I have no authorisation for that either.

Maybe not an Excel question per se but this is where the problems are occurring so I'll post it here. I constantly have issues where I go to open one of my workbooks (on a network) and it comes up with the msgbox stating that "file is locked for editing by 'another user' " or by an actual user...

Probably for the same reason as me when people tell me that my imaginary friend isn't real.

That was..... strange