View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
TerryK[_2_] TerryK[_2_] is offline
external usenet poster
 
Posts: 16
Default Running Excel from a Server

This may be a little crude but it should work. By setting the Macro security level to Medium the user will have the option of disabling all macros or VBA code when the spreadsheet is opened. Of course this setting will apply to all spreadsheets with code in them

To change the security level on each local application of Excel go to Tools/Macros/Security. Choose the radio button for Medium

TerryK