+ Reply to Thread
Results 1 to 2 of 2

Me.Hide Userform runtime error in Office 365??!!

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    India
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2010
    Posts
    4

    Me.Hide Userform runtime error in Office 365??!!

    Hello Excel Gurus,

    Need your help..i am getting a runtime error [Run-time error'-2147418105(80010007)] while running a macro in Office 365.
    This macro works fine in excel 2007.

    On debugging i found this is due to 'Me.Hide' in the Userforms.
    When i remove 'Me.Hide' the macro works fine in Office 365, however, i cannot use the same macro in excel 2007 as the Userform does not Hide then.

    Any suggestions on how to resolve this so that i can make the same version of macro work on both excel 2007 & Office 365.

    Many thanks in advance !!

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Me.Hide Userform runtime error in Office 365??!!

    Please Login or Register  to view this content.

+ 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. If Runtime error Shows up then Give a Msgbox (for userform)
    By ohboyherewegoagain in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2014, 09:20 AM
  2. [SOLVED] Runtime error on UserForm
    By DJvdW in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-06-2013, 10:16 AM
  3. Getting runtime error when sub executed through userform change rather than directly
    By drew.j.harrison in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-28-2013, 12:32 AM
  4. Replies: 13
    Last Post: 01-14-2013, 03:45 PM
  5. RunTime error with UserForm!.Show
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-03-2011, 09:42 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