File status = "read only"
 

Put something in the "ThisWorkbook" Module in the Workbook_Open event.

You can refer to "ThisWorkbook.ReadOnly and maybe put a msgbox in to let
them know that it's READ ONLY.

--
HTH,

Barb Reinhardt



"Jock" wrote:

On occasion, users have 'forgotten' they are in a WB as 'read only' and then
have to re-enter the data when they go back in with read/write access.
Using VBA, is it possible to put something like:

If WB file status = read only
then sheet1.entire range.cell colour = light grey
else
end if
?
This would make it obvious to anyone using it whether it was read only or not.

Thanks.
--
Traa Dy Liooar

Jock