+ Reply to Thread
Results 1 to 3 of 3

Shared File Causing 1004 Error

  1. 02-07-2014, 07:30 PM #1
    cmore is offline
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    Shared File Causing 1004 Error

    Hi,

    I'm wondering if anyone might know, why my code would hit a run time error on a shared file? It works fine unshared. This is on a ActivateSheet Worksheet Event, Code is housed in a Module and called when activated

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Thanks for your help in advance
    Reply With QuoteRegister To Reply
  2. 02-07-2014, 09:39 PM #2
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,155

    Re: Shared File Causing 1004 Error

    You're trying to change the Data Validation. You can't do that on a shared workbook.


    http://office.microsoft.com/en-gb/ex...005201080.aspx


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 02-07-2014, 11:07 PM #3
    cmore is offline
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    Re: Shared File Causing 1004 Error

    Thanks. Simple enough..............any possibility of a workaround?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VisibleItemsList is causing error: 1004
    By kkode in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2012, 05:44 PM
  2. CSV empty file causing an error
    By scantron in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2012, 04:31 PM
  3. Run-time error '1004': Macro error, only when shared
    By Pergo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2011, 12:57 PM
  4. shared workbook runtime error 1004
    By Nigel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-02-2005, 02:09 PM
  5. Run-Time Error 1004 Shared Workbook
    By jmagdziarz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2005, 07:35 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1