I have a control button on a worksheet that when clicked on it runs a code in VBA. For whatever reason this button is not working on my second computer. Both machines are running windows 10. There is another button on the worksheet that runs a macro and it works fine on both machines. Is there a setting in Excel that i need to change? It is the same workbook being used on both machines.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
steve the fish
Well-known Member
- Joined
- Oct 20, 2009
- Messages
- 8,894
- Office Version
- 365
- Platform
- Windows
What does happen when you press the button? Nothing? Error? Which line?
Upvote
0
Excel Facts
How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
steve the fish
Well-known Member
- Joined
- Oct 20, 2009
- Messages
- 8,894
- Office Version
- 365
- Platform
- Windows
Ill take a guess its this line:
Its almost certainly a different port on the different machine.
Code:
Application.ActivePrinter = "\\SBS2011\Sales Copier on Ne09:"Its almost certainly a different port on the different machine.
Upvote
0
