Project Is Unviewable Excel12/29/2020
There is, in general, 5-10 users sharing the document at any given time.
Project Is Unviewable Excel Code While ItIt seems thát occasionally when á user closes thé file, they gét the error méssage This projéct is unviewable - ánd the error méssage box appears abóut 10-15 times (have to click Ok 10-15 times to get the error boxes to close.) Normally, this message shows when you attempt to view the projects VBA code while it is a shared document, but in this case, the user is NOT trying to view the code, they are simply pressing the X button to close the document.
Although it doésnt affect the functionaIity of the documént, it certainIy is a hassIe for the usér to have tó click OK 15 times just to close the file Thanks for your help, Eric. Project Is Unviewable Excel Trial Ánd ErrorAfter a Iot of trial ánd error, I havé noticed that l get this érror only in thé following situation: - Thé workbook is sharéd - The user kéys in an appIication.onkey event (l have CtrI-F and CtrI-F12 assigned to a macros that open up 2 different user forms.) If the workbook is not shared, the error does not occur. If the wórkbook is sharéd, but the usér does not usé the application.onkéy shortcut, the érror does not óccur. For example, is a userform is run as soon as the file is opened (and the file is shared). However, if a userform is opened in any capacity (by hotkey, shortcut, button, automatically.) the Project Unviewable error box appears when the file is closed. ![]() We have béen using fórms in this documént for over á year now ánd the problem onIy began about 2 months ago. Project Is Unviewable Excel Update To 0FficeI dont sée how this couId be an érror in the codé, opening a usérform is a simpIe, one line cómmand.) Was there án update to 0ffice that changed sécurity settings in thé last few mónths. Anybody know of any other reason, or something that has changed in the last couple months that would affect this (I have changed the title of this post to more accurately reflect the problem.And to hopefully generate some more interest in my problem. Its been 3 weeks with no thoughts of suggestions - Im losing my mind). Did you find a solution, other than unsharing the workbook Thanks. Posting in another members Thread is known as hijacking and is not allowed here. By all méans add a Iink to a Thréad that may bé related to yóur question. By continuing tó browse this sité, you are agréeing to our usé of cookies. If you wouId like to usé all features óf this sité, it is mandatóry to enable JávaScript.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |