'Project is unviewable' error

[SaraWitch]

Hello peeps,

I have a shared workbook containing various (complex!) formulas and macros.

A small number of users are getting the pop up error, 'Project is unviewable'. If they click okay, the book closes. After a quick Google, 'old' macros are being cited as the problem, but all my macros were created in Office 365 (at the time of the new spreadsheet).

Any ideas why this is happening for some users and not others?

Ta muchly!

 

[6StringJazzer]

You can't edit/view macros in a shared workbook. You have unshare, edit, then re-shared.

 

[SaraWitch]

Thank you, Jeff.

Yes, I know that you can't edit/view macros in a shared workbook, and I don't want people to - I just want them to update the data, which they have been doing successfully until recently where a couple of users are getting the aforementioned error. This has never happened before and I can't find a way of resolving it, hence my post for any advice...

 

[6StringJazzer]

What is the user doing to get that message? In my experience the only way you get that is to attempt to edit the VBA, hence my response.

Are you asking for a way to prevent the user from attempting to see the VBA?

 

[SaraWitch]

This is the strange thing, Jeff - the user is just opening the workbook and this message appears preventing them from going any further (they haven't even fully opened the document to even try and view the VBA (which I don't want them to and understand that you can't in a shared workbook)).

I have tried unsharing and resharing the document, I have cleared old user entries in the shared list, I have checked macros and VBAs, but can't work out why this has suddenly started for some users but not others...

So my query is, why is this message appearing for some users who are only attempting to open the document (they are not doing anything other than opening the document to get this message, which prevents them from doing so, so they can't even access the document to edit data as they normally do)?

 

[6StringJazzer]

Is there a Private Sub Workbook_Open() in the ThisWorkbook module? If so, what is the code?

 

[SaraWitch]

No, but I have a Private Sub Workbook_BeforeClose:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If MsgBox ("Have you cleared all filters?", vbQuestion + vbYesNo) = vbNo Then
Cancel = True
End If
End Sub

And then there's a couple of different Private Sub Worksheet codes on different sheets.

I really can't get my head around it as it's been working fine for months until just recently!

 

[6StringJazzer]

Well I have to say that's a head-scratcher. I haven't seen this just from opening the file.

 

[SaraWitch]

Me neither! I appreciate your time, thank you, Jeff.

If anyone else out there has come across this and has found a solution, I'd be pleased to hear from you!