advise if active workbook is read only

E

EXCELMACROS

Hello guys,

I have more than one user using the same SS, I want to begin my macro with a
condition,

if ActiveWorkbook is readonly then
msgbox("abc")
exit sub
else
.... my macro
end if

Thank you in advance,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top