Deny access to read-only workbooks

Thanks Richard,

I am fine on how a read only works. I understand all of that. What i want is that they can't open a read only. If it is free it opens, if not then is says unable to open, file in use etc etc and they can go no further. Is it possible to do this?

E

Hi Emmaly

I'm pretty sure that this is possible, however it would require macros. If the user disabled macros then they would be able to open the workbook anyway. There are ways to limit the impact of this, but doing this would mean that you wouldn't be able to open the workbook without enabling macros.

Would this be ok?

Hi Kyle,

I was worried this might be the answer. To give you a brief idea of the problem, we have an office in Japan who are NOT very computer competent. There are sequential orders numbers in a sheet that they need to select and apply to their orders. So multiple people are going in on read only and therefore picking the same order number and chaos ensues!

If we can't get them to read and understand the statement "This file is locked for editing by 'X', would you like to open as read only" i am worried that the likelihood of them enabling a macro is quite slim. Their english is good, but they seem to just dismiss the message.

I don't know what to do!

Oh that looks perfect!! Thanks Martin

Just be aware Emmaly that if the user disables macros then they will be able to open the workbook anyway

Oh boo, so that is the same problem we had before.

Urgh, friday problems, i hate them!!

You can set all the worksheets to very hidden and place a password on the VBA code, this would hide all the worksheets if the user opens without macros. You can then adapt the code to unhide all the worksheets

Do i have to input code for this too?
This is the first piece of code i have ever entered. I am going on a course in February
But if you could let me know what i need to enter to make the hidden thing work that would be brilliant.