Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Links to mapped drive change to refer to local hard drive | Links and Linking in Excel | |||
Can I save to hard drive AND my flash drive at the same time? | Excel Discussion (Misc queries) | |||
Userform Local Drive & Network drive question | Excel Programming | |||
Identify CD-Rom drive | Excel Programming | |||
Pasting a range of information from a foler on F Drive to another folder on same drive | Excel Programming |