Google Sheets Persmissions for App Scripts

[Malcolm Sokol]

I have a sheet that is stored on a company shared folder and the access has named users from our administered gmail domain and has been expanded to include an outside users with a gmail account.  The folder is also marked as shared for access with the file id like anyone wiht the id is premitted.  So if I access chrome with any login either with th ecompany domain ot the other user with the gmail account and I go to sheets and open the file I have full access and all are editors so all have access to App Scripts editor. Further all scripts execute including an onLoad and onEdit and scripts assigned to shapes.   In addition I have a web page and there is a section that opens an iframe with the worksheet assigned to the iframe.  I have a button click to open that iframe with the embedded sheet and if the chrome account is one of the company domain names the ifrrame opens and I have full sheet accessiibility.  However if I open when logged into chrome with the gmail account the sheet opens in the frame and I get a message popped up saying reconnecting that does not go away.  I also get a message about the  account domain has been switched and if I hit okay it only closes the popup but I the reconnect does not do away.  I may be able to access the sheet but if I do i can only do basic edit furnctions.  None of my scripts copletes and if they start to run I get a 500 error.   If I click the login button at the top of the screen and manage to login,  I am no longer in my  iframe and if that would work,  I need to have the login return to the iframe and not an independent window with the sheet.  It's complex but I want the iframe to work for  the gmail account choome user id which account has access as a normal sheet user but not via an iframe imbedded activity.

[Malcolm Sokol]

Follow up to original post.   This appears to be what happens when there is a issue with a  possible incompatibility in the chrome id of the browser.  The ifarme opens on a user prompt in a web page with  another button to closee that entired div (butotn and iframe).  When opened,   a window opens with a messge about account issues and requests sign in.  When that is clicked the window closes and after 3 or 4 seconds a red warning message at the top of the frame says something went wrong and presents a Reload button at the right of the mssage. Clicking the reload button resolves any issues and the sheet displayed in the iframe funcions with full edit functions and all scripts funciont including onLoad and onEdit.  Howeveer there is some inconsistency int he appaerance of the warning and it is possible this never gets posted i which case the iframe displayed sheet is not functioning as required , has not scripting activity and may not save normal edits if they are actually made to the sheet.  Also there may be a persistnece of a massage at lower left saying reconnecting tht does not do away.  Work around is to close the div on the webpade using my Done button which closes the ifreame and redo the user action from scratch  This appaers to allow the next action to function properly where a warning and Reload is needed.  But I cannot guarantee that I alwasys see that warning messge and there could be some timeing issues or whatever in what Google is doing behind the sceens and interacting with my web page.