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

Hi,

I'm trying to figure out how to write VBA code to identify the drive letter
that a spreadsheet (in Excel 2000) was loaded from, and then to delete a
worksheet if it was loaded from drive C or D.

The idea is to prevent users from saving a copy of the spreadsheet to their
local drive. I also want to create a text message that tells them they must
go to the central drive to use this sheet.

I'd appreciate any help.

Thanks,

Brian