Results 1 to 6 of 6

HELP NEEDED: How to enabled macro with locked cells

Threaded View

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    75

    Wink HELP NEEDED: How to enabled macro with locked cells

    Dear Excel Expert,

    Is there any way where I can used my macro-enabled sheet while locking certain cells in my excel sheet?

    Attached is part of my macro VBA code, thanks for your advise!

    Sub Apr()
    '
    ' Apr Macro
    '
    
    '
        ActiveSheet.Range("$B$5:$K$668").AutoFilter Field:=2, Criteria1:="April"
    End Sub
    Sub Mar()
    '
    ' Mar Macro
    '
    
    '
        ActiveSheet.Range("$B$5:$K$668").AutoFilter Field:=2, Criteria1:="Mar"
        ActiveWindow.SmallScroll Down:=-108
        Range("C219").Select
    End Sub
    Sub Feb()
    '
    ' Feb Macro
    '
    
    '
        ActiveSheet.Range("$B$5:$K$668").AutoFilter Field:=2, Criteria1:="Feb"
        ActiveWindow.SmallScroll Down:=-30
    End Sub
    Sub Jan()
    '
    ' Jan Macro
    '
    
    '
        ActiveSheet.Range("$B$5:$K$668").AutoFilter Field:=2, Criteria1:="Jan"
        ActiveWindow.SmallScroll Down:=-18
    End Sub
    Last edited by Fotis1991; 05-29-2014 at 05:39 AM. Reason: pls use code tags around your codes!!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and paste locked cells, and have pasted cells retain LOCKED status.
    By stratloveslenny in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2014, 03:05 PM
  2. Replies: 3
    Last Post: 04-12-2014, 04:47 AM
  3. VBA code needed to stop people selecting locked cells.
    By Jed Shields in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2013, 11:27 AM
  4. Macro into locked cells
    By elude3xo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2006, 04:11 AM
  5. How to unlock locked cells by MACRO?!
    By Petr Nìmeèek in forum Excel General
    Replies: 1
    Last Post: 03-09-2006, 08:26 AM

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