View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EXCELMACROS EXCELMACROS is offline
external usenet poster
 
Posts: 43
Default advise if active workbook is read only

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,
--
Thank you...