I wrote a line of code to rename worksheets in my excel spreadsheet, and it executes perfectly at home where I have 2003 software, but at work where I need it to run, I get the following message: System errror -2147417843 An outgoing call cannot be made since the application is dispatching an input synchronous call.
Each worksheet has that code referencing a different cell. It works perfectly at home, but not at work, and I am suppose to show my boss the program I created today...help!Code:Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveSheet.Name = Sheets("Set-up Page").Range("B2").Value End Sub
Your answer seems to be another question unless I am reading it wrong, or I am just cluless, but I don't understand how what you wrote relates to my question. Clarify if you were attempting to answer my question.
There are currently 1 users browsing this thread. (0 members and 1 guests)