+ Reply to Thread
Results 1 to 3 of 3

Can't access other excel books when userform is open Mac

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    London
    MS-Off Ver
    Excel 2010 Mac
    Posts
    19

    Can't access other excel books when userform is open Mac

    Hi guys!

    I'm currently working on a userform that people have to fill in so that we can track projects that are running. Some people need to access another excel workbook to fill in the userform. I have tried to use:

    Please Login or Register  to view this content.
    But it doesn't work. There is also no option on the properties window to allow me to make it modeless.

    All of the solutions I've seen seem to be for the Microsoft version of excel, but I'm running excel on Mac. I would really appreciate any help on this.

    Thanks in advance.

  2. #2
    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
    44,447

    Re: Can't access other excel books when userform is open Mac

    Set the property: ShowModal = False. (But then, I am using Windows)


    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


  3. #3
    Registered User
    Join Date
    05-13-2013
    Location
    London
    MS-Off Ver
    Excel 2010 Mac
    Posts
    19

    Re: Can't access other excel books when userform is open Mac

    Thanks Trevor, but if that's on the properties window, then no I won't be able to use that.

+ 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. open books,ink cells and then save books and move on to the next book
    By Desmond_Mocumi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2013, 02:34 PM
  2. need help to minimize the windows and allow other excel work books to open
    By Ignesh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2012, 08:56 AM
  3. how to open an Access table from excel userform
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2009, 06:58 AM
  4. Introductory and Intermediate VBA Books - Excel & Access
    By Tony in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2006, 09:35 AM
  5. Replies: 4
    Last Post: 03-18-2005, 04:13 AM

Tags for this Thread

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