+ Reply to Thread
Results 1 to 4 of 4

Runtime Error 1004

  1. #1
    Registered User
    Join Date
    01-30-2013
    Location
    Ohio, usa
    MS-Off Ver
    Excel 2003
    Posts
    10

    Runtime Error 1004

    Hi All,

    I made a copy of a previously working workbook for another facilty on our campus, and the macros got all buggy, and i dont know how to fix it. Workbook is too large to attach, But below is a copy of the code to show what the error message says when I click "debug"

    Please Login or Register  to view this content.

    The Bold letters are what is highlighted when i open the debug screen

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
    Last edited by 6StringJazzer; 01-29-2014 at 04:40 PM. Reason: code tags

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Runtime Error 1004

    Is the workbook protected?
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    01-30-2013
    Location
    Ohio, usa
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Runtime Error 1004

    yes it is protected

  4. #4
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Runtime Error 1004

    If workbook window structure is protected, you may not change visibility of sheets unless you first unprotect the workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Error: Runtime Error 1004: AutoFilter method of Range class failed
    By jl22stac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2013, 07:27 PM
  2. [SOLVED] Range error in code, runs alone but not inside my full program, giving runtime error 1004
    By charizzardd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2012, 03:34 PM
  3. Runtime Error 1004
    By strat_640 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2007, 09:10 AM
  4. [SOLVED] runtime error 1004
    By valdesd in forum Excel General
    Replies: 0
    Last Post: 10-12-2005, 01:05 PM
  5. Excel 2003 Macro Error - Runtime error 1004
    By Cow in forum Excel General
    Replies: 2
    Last Post: 06-07-2005, 09:05 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