Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
"Cannot access read-only document" (I get this error when I try to open an Excel file) | Excel Discussion (Misc queries) | |||
"Cannot access read-only document" (I get this error when I try to open an Excel file) | Setting up and Configuration of Excel | |||
XCEL FILE REC'D AS READ ONLY -- HOW TO NOT BE "READ ONLY" | Excel Discussion (Misc queries) |