Results 1 to 6 of 6

Thread: XLSM Made in Excel 365 in Windows Removed Whenever Opened on Mac

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,106
    Location
    Welcome to the VBAX Forum Abbaskip. There's nothing there that pops out as unworkable to me. Are you able to create an xlsx format and try to run that on a Mac. That will test is the standard file is an issue. If it accepts that then we need to look at the VBA side of things. I'm assuming that "Rectangle1" is a named range rather than a Shape?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  2. #2
    VBAX Newbie
    Joined
    Jun 2023
    Posts
    4
    Location
    Quote Originally Posted by Aussiebear View Post
    Welcome to the VBAX Forum Abbaskip. There's nothing there that pops out as unworkable to me. Are you able to create an xlsx format and try to run that on a Mac. That will test is the standard file is an issue. If it accepts that then we need to look at the VBA side of things. I'm assuming that "Rectangle1" is a named range rather than a Shape?
    The xlsx opens and works completely on Macs once the file is opened and "repaired" so it definitely seems to be the vba

    Rectangle1 is a shape - is that an issue?

    I originally had a form button (not ActiveX), but changed to a rectangle shape in case the button was causing issues.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •