Results 1 to 4 of 4

Modifying VBA to include one additional worksheet?

Threaded View

jonvanwyk Modifying VBA to include one... 12-22-2010, 10:20 AM
Domski Re: Modifying VBA to include... 12-22-2010, 10:26 AM
romperstomper Re: Modifying VBA to include... 12-22-2010, 10:26 AM
jonvanwyk Re: Modifying VBA to include... 12-22-2010, 11:01 AM
  1. #1
    Forum Contributor jonvanwyk's Avatar
    Join Date
    06-28-2010
    Location
    Iowa, USA
    MS-Off Ver
    Excel 2010
    Posts
    452

    Modifying VBA to include one additional worksheet?

    
    Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"
    Application.DisplayStatusBar = False
    If IsNumeric(Sh.Name) Then Sh.ScrollArea = "A1:O31"
    End Sub


    The above code is presently used to make sure no one is able to scoll outside of a specified area (A1:O31). My workbook has 27 worksheets, of which 26 are numerical. 1 of my worksheets is labeled "Menu", and so the above code is not applying to it. This is okay, initially, because I want to limit ShScrollArea = "A1:M12" on the "Menu" worksheet. How do I modify the above code to accomplish this?
    Last edited by jonvanwyk; 12-22-2010 at 11:01 AM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1