View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Brian C Brian C is offline
external usenet poster
 
Posts: 37
Default Identify Load Drive

Thanks Guys!
I actually already disabled the save/save as, and made it so that the
sheets are veryhidden and tells the user that the workbook can't be used if
macros are disabled. So, the last piece is to prevent someone from disabling
the macros as they launch the sheet, and then saving it on their c drive. If
they do that and load from C, it will give message "Must Enable Macros" and
the other sheets will be veryhidden.

If they enable macros, then I need this macro to detect the launch drive,
and if it's C or D, then delete the "Input" and "Calculations" sheets so they
can't use. Then create a message box that tells them they have to launch it
from the posted location. I've been working on the code, but can't get it
quite right. I'm pretty new to VBA.