Hello again everyone, Does anyone know if it would be possible to store a macro on a usb flashdrive and have the macro available to any workbook only when the drive is inserted. Ive never heard of such chaotic method but this is a security idea Im toying with and would appreciate any help or ideas.. Thanks in Advance!
Run Macro From Removable Flash Drive
-
-
-
Re: Run Macro From A Removable Usb Flash Drive
You could put a workbook on the flash drive, put your macros in that workbook. You'd have to have the workbook open for the macros to work.
What are you trying to keep secure. Excel is no good for secrets. If security is very important to you, you should probably use a different program.
-
Re: Run Macro From A Removable Usb Flash Drive
Sounds interesting...
i've not tested this but it's a good starting point... save your modules on your flashdrive then in excel click on Tools then options. on the General tab you should see At Startup open all files in... try putting your dir path in there.
HTH
z
-
Re: Run Macro From A Removable Usb Flash Drive
Hey there Mikerickson and Zimitry, Thanks for your input on this. My issue is that people from other companies occasionally use our equipment and by implementing my codes, we have become extremely efficient and profitable and I don't want all my time and effort ending up in the wrong hands! Ive already tried the workbook idea and it worked fine for the macro, but when saving, the macros were also saved! I'm going to try out Zim's thought tomorrow and see how that pans out, that's an option that I didn't think about.. Thanks guys I appreciate the ideas, Ill let you know what happens!
-
Re: Run Macro From A Removable Usb Flash Drive
You could try making an addin then store that on the USB, but how would anyone obtain your code anyway. If the addin was on the hard drive the would not be in the workbook, so merely copying the workbook woldn't take the code.
-
-
Re: Run Macro From A Removable Usb Flash Drive
Hi,
If zimitry’s idea is not working try this.
Create a “Master” Workbook with all the codes and save it on the USB Stick. Create a folder somewhere on your computer and copy the data the macro should work in into this folder. So each time the macro should run through a document you have to copy the sheet into this folder.
You have to add a few things to your code. First it should open the spreadsheet saved in the folder. Than rewrite the macro so that it is not running the code through the “master” sheet. Instead it should activate the other window and run the scrip there.Does it make sense?
If hope you get my idea, if not please let me know!
Martin
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!