Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: VBA code runs in excel 2003, but gives error message in excel 2010

  1. #1
    Join Date
    19th November 2008
    Posts
    93

    VBA code runs in excel 2003, but gives error message in excel 2010

    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.

    The code

    VB:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
        ActiveSheet.Name = Sheets("Set-up Page").Range("B2").Value 
    End Sub 
    
    
    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!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    19th November 2008
    Posts
    93

    Re: VBA code runs in excel 2003, but gives error message in excel 2010

    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.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 8
    Last Post: July 13th, 2011, 05:15
  2. Replies: 1
    Last Post: May 8th, 2011, 03:55
  3. Replies: 2
    Last Post: February 10th, 2011, 01:22
  4. Excel 2010 vba issues with code from 2003-2007
    By JR869 in forum EXCEL HELP
    Replies: 5
    Last Post: August 2nd, 2010, 03:25

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno