Combo Box issues - read-only workbook

[Stockdale]

I have an issue with a couple of combo boxes - when the workbook is editable, they work perfectly as designed. However, when the workbook is in read-only mode, Excel asks the user if they wish to reopen the workbook every time a selection is made within the combo box.

The workbook must remain in read-only mode for other users to access from a shared content server.

Does anyone have any ideas please? It's driving me crazy!

 

[Andrew Poulsom]

Welcome to MrExcel.

What VBA code is assigned to the ComboBox?

 

[Stockdale]

Welcome to MrExcel.

What VBA code is assigned to the ComboBox?

I've just realised I meant to say List Box, not Combo Box. Apologies Andrew!

I created the List Box via the Developer tab, so the code is minimal:

Sub ListBox6_Change()
End Sub

The input range is a list of cells containing names of years (2011-2012, 2012-2013 etc) - the reason for the List Box is to select a year and that range will highlight on a line chart below.

I'm a newcomer to these Developer tools so sorry if I have misunderstood.

 

[Andrew Poulsom]

What's the exact text of the message that Excel gives you? I don't see why just selecting a value from a ListBox in a read-only workbook would prompt a re-open.

 

[Stockdale]

What's the exact text of the message that Excel gives you? I don't see why just selecting a value from a ListBox in a read-only workbook would prompt a re-open.

"file_name.xlsm is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen file_name.xlsm?"

Yet the file is absolutely fine when editable. Very odd.

 

[Andrew Poulsom]

Do you have any VBA code in the workbook that may be reopening it?

 

[Stockdale]

Do you have any VBA code in the workbook that may be reopening it?

I only have one other module in the workbook:

Public Function highlightSeries(seriesName As Range)
Range("valSelOption") = seriesName.Value
End Function

This is based on the dashboard tutorial from chandoo.org. So, the VBA code acts as a hyperlink of sorts, but there is nothing there to suggest the reason for the dialog box to appear.

 

[Stockdale]

I have just ran another test in saving the workbook as read-only to my local drive. The List Box worked without the message. Therefore, the problem must lie with the location of the server, which is OpenText Content Server 10.

But I still don't understand what the server is doing to cause this?

 

[Andrew Poulsom]

Neither do I, sorry.