ExcelBanter - Read only mode

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Read only mode (https://www.excelbanter.com/excel-programming/307445-read-only-mode.html)

Patric[_2_]

Read only mode

Hi,

Does anyone have a suggestion how to show in Excel XP
for the user if they have opened a worksheet in
Read Only mode or not?

Best regards

Tom Ogilvy

Read only mode

? activeworkbook.ReadOnly
False

will give you the ability to tell with code. How you would inform the user
would be up to you.

--
Regards,
Tom Ogilvy

"Patric" wrote in message
...
Hi,

Does anyone have a suggestion how to show in Excel XP
for the user if they have opened a worksheet in
Read Only mode or not?

Best regards

All times are GMT +1. The time now is 10:09 PM.