View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GLT GLT is offline
external usenet poster
 
Posts: 12
Default Testing of a workbook is in read only mode

Hi,

I have three macros in my workbook however I only want these macros to be
allowed to run if the workbook is protected by being read-only.

This would mean if any of the macros run then it would check to see the
status of the workbook first - could anyone advise how to acheive this?

Thanks,
GLT.