[sc-issues] [Bug 118376] New: Macro broken after upgrade from 3.1 to 3.3.0

http://openoffice.org/bugzilla/show_bug.cgi?id=118376

        Issue Type: DEFECT
           Summary: Macro broken after upgrade from 3.1 to 3.3.0
    Classification: Application
           Product: Spreadsheet
           Version: OOo 3.3
          Platform: PC
        OS/Version: Windows XP
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: P3
         Component: ui
        AssignedTo: [email protected]
        ReportedBy: [email protected]
         QAContact: [email protected]


I have a workbook with multiple worksheets. I have Macros that are tied to
objects in the worksheets that can be used to select different sheets within
the workbook. (This is a workbook that has been converted from Microsoft
Excel).

The following is a snippet of code from the Macro>

-Snip-

Sub Firstnineweeks()
'
' Firstnineweeks Macro
' Go to First Nine Weeks
'
' Keyboard Shortcut: Ctrl+f
'
    Sheets("1st Nine Weeks").Select
    Range("A1").Select
End Sub
Sub Menu()
'
' Menu Macro
' Go to Menu
'
' Keyboard Shortcut: Ctrl+m
'
    Sheets("Menu").Select
End Sub

-Unsnip-

The first sub works fine. The second sub does not work if the Menu worksheet is
the first sheet in the book, however, if there is a sheet AHEAD of the Menu
sheet it works fine. This code worked correctly in Version 3.1 but gives the
following error in 3.3.

Following is the error that the code returns:
=======================================
BASIC runtime error.
'1'

Type: com.sun.star.uno.RuntimeException
Message:
=======================================

-- 
Configure bugmail: http://openoffice.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification
from Bugzilla. Please log into the website and enter your comments.
---------------------------------------------------------------------
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help