View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mmc308 mmc308 is offline
external usenet poster
 
Posts: 19
Default Close Workbook If user disables macro's

I am currently looking for a way to close a workbook if the user has a lower
security setting than meduim or the user chooses to disable macro's

The reason for this I have a macro in the work book that checks for a data
and lock the worksheet if the date has passed, however if they disable the
macro's they can work on this worksheet

Any idea would be appreciated
TIA
Michael