Corrupt

[yogurtspoon]

Hi, I am deliberately trying to corrupt an excel file if the file gets moved to a different folder. What is the best way to approach this? I was thinking maybe creating a file structure within the excel file so when it does get moved, the file gets corrupted.

[Logit]

.
You can create a macro that deletes portions of the coding within the workbook. Combine that with a macro that verifies the workbook is 'sitting' in the specified directory / folder. If it isn't
run the 'kill' macro.

As far as that goes, you could actually 'kill' ( delete ) the entire workbook under the same circumstances.

A better approach (user friendly) would be to cause the workbook to cease to function unless it is in the specified directory. If the user moves the file back, it functions as usual.

[yogurtspoon]

Hi thank you 'logit'
how do I do the "better approach" ? could you provide more detailed instructions please? Thank you so much

[Logit]

.
Let me provide an overview of the process ... you research the Forum and the Internet for example code that you can implement in your project ... then come back with your questions after that.
If you are given the project outright the learning curve is omitted.

#1:
In the Workbook_Open module you'll want to check that the workbook is located in the correct location. Search for an explanation of the Workbook__Open module, verifying location of
Active Workbook, and how to verify that location against the required location.

#2:
If the workbook is in the correct location, run it.

#3:
If the workbook is not in the correct location, advise the user of such (MsgBox, UserForm notice, etc.), then close the workbook without saving.

It is understood the above three steps may at this point seem overwhelming but they are not. Break the process down into small steps in the order indicated above. You can do it.

I'll answer your questions and help you along the way.

[TMS]

Your big issue is that, for any solution to work, the user MUST enable macros (and not prevent Workbook_Open.AutoOpen macros from running).

So you would have to ensure that the workbook was unusable without the macros. That's doable but takes a bit of effort to set up.

[yogurtspoon]

'logit' thank you thank you thank you your instructions really helped thank you so much for having so much patience explaining

[Logit]

You are welcome. Let's see what you have when you put it together.

Cheers.