Limiting execution of VBA macro to specific workstation in a shared spreadsheet

**DoctorLemon** · 07-02-2014, 03:00 PM

Hi, everybody! (No, I'm not Doctor Nick.

)

I was wondering if someone could help me modify the code of my VBA macro in order to limit execution to just one specific workstation in a shared spreadsheet. The problem is that everyone who has the spreadsheet open will attempt to run the VBA macro when the timer goes off.

Here is the code for the timer to invoke the VBA macro "SaveDate":

Please Login or Register  to view this content.

Here is the actual code for the VBA macro "SaveDate" that is being invoked by the timer:

Please Login or Register  to view this content.

The goal is to have only the server (workstation name is TwerkingBuddha) be the one to execute the macro, thereby saving it locally without having the other users compete over saving it.

Any help would be greatly appreciated. Thanks!

Regards,
Doctor Lemon

**Olly** · 07-02-2014, 03:13 PM

Try:

Please Login or Register  to view this content.

**DoctorLemon** · 07-02-2014, 06:26 PM

Thank you, sir. That worked exactly as I intended for it to.

The only modification that I had to make was putting the computername (i.e. TWERKINGBUDDHA instead of TwerkingBuddha) value in all capital letters.

Repped!