Restrict Macro

msfatman

Board Regular
Joined
Apr 10, 2008
Messages
110
I've created a spreadsheet with loads of macros and lots of help from this site.

There is one macro that I want to only run if the spreadsheet is on my machine and based on my user/login name.

I thought I'd seen an article on this but cannot find it. Does anyone know how I can this up?
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
You can include something like this near the top of the macro

Code:
If Environ("username") <> "msfatman" Then Exit Sub

Replace msfatman with your Windows logon name.
 
Upvote 0

Forum statistics

Threads
1,191,175
Messages
5,985,111
Members
439,940
Latest member
Kyrad42

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top