I have 13 buttons in a spreadsheet that sort data by color. This is to sort our data for each user. So each button is the initials of user. I want it to run the command button of the user that opens it. So, I have figured out how to get the user name, and then using that to assign a cell with the users initials. What I cant figure out is how to program it to run when open.
So in cell A1 I have users initials "AAA". How do I get the spreadsheet to run command button AAA when that user opens it, or run command button BBB when user BBB opens it, and so fourth. All the command buttons are named per the persons initials.
Thanks
So in cell A1 I have users initials "AAA". How do I get the spreadsheet to run command button AAA when that user opens it, or run command button BBB when user BBB opens it, and so fourth. All the command buttons are named per the persons initials.
Thanks