VBA in shared file

[ragnarok75]

I have a shared excel file that is running the following code:

DestSht.Range("N9", "N" & LastRwEnd).Select
    With Selection.Validation
        .Delete
        .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=$O$2:$O$4"
        .IgnoreBlank = True
        .InCellDropdown = True
        .InputTitle = "Priority"
        .ErrorTitle = ""
        .InputMessage = ""
        .ErrorMessage = ""
        .ShowInput = True
        .ShowError = True
    End With

The code runs fine when the file is exclusive, but as soon as I share the file the same code generates an error and the list\combobox is never created. Any ideas?

 

[SkipVought]

Hi,

Features that are unavailable in shared workbooks


You can access the following features only if you stop sharing the workbook.

You cannot use shared workbooks (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) on Web servers.

Unavailable feature Alternatives
Create lists (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.) None
Work with XML data, including:
Import, refresh, and export XML data
Add, rename, or delete XML maps
Map cells to XML elements
Use the XML source task pane, XML toolbar, or XML commands on the Data menu
None
Insert or delete blocks of cells You can insert entire rows and columns.
Delete worksheets None
Merge cells or split merged cells None
Add or change conditional formats Existing conditional formats continue to appear as cell values change, but you can't change these formats or redefine the conditions.
Add or change data validation
.....

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]