VBA code does not work on shared workbook

**den_1985** · 03-16-2017, 06:26 AM

Hi,

I have a VBA code that works perfect when workbook not shared!!!

How can I fix it to work on shared workbook?

Thanks a lot!!!

**MarvinP** · 03-16-2017, 06:46 AM

Hi den,

If you mean "shared" is the workbook is one OneDrive and two people are working on it, you are using Excel Online. Excel Online is looking at a browser view of the data and VBA doesn't work through a browser. You will need to download the workbook to each individual computer to have the VBA work. Then you aren't sharing it. Excel Online doesn't support VBA. It seems you can edit the data that is shared but the VBA doesn't work. Read:
https://blogs.office.com/2014/04/14/...in-april-2014/

**den_1985** · 03-16-2017, 06:54 AM

Hi Marvin,

Thank you for you response.

That what I am talking about:Share Workbook.PNG

**xlnitwit** · 03-16-2017, 07:00 AM

There is a list of all the features that do not work in Shared Workbooks here- https://support.office.com/en-us/art...ad=US&fromAR=1

**den_1985** · 03-16-2017, 07:56 AM

The code is should to put back My List (Located in K3:K7) when a set of cells cut:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next

Dim MyList(5) As String
MyList(0) = 10
MyList(1) = 2
MyList(2) = 3
MyList(3) = 4
MyList(4) = 5
MyList(5) = 6

With Range("k3:k7").Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
Operator:=xlBetween, Formula1:=Join(MyList, ",")
End With

End Sub

**xlnitwit** · 03-16-2017, 07:57 AM

As listed in the article, in a shared workbook you cannot add or change data validation. You have to unshare the workbook if you need to do that.

**MarvinP** · 03-16-2017, 08:23 AM

I stand corrected, in that VBA may be allowed in shared workbooks. It just seems you can only do "allowed" things with your VBA.

I find a good and long discussion of shared workbooks at:
http://blog.contextures.com/archives...ooks-in-excel/

**den_1985** · 03-16-2017, 08:56 AM

Thank you all

VBA code does not work on shared workbook

LinkBack

Thread Tools

Rate This Thread

Display

VBA code does not work on shared workbook

Re: VBA code does not work on shared workbook

Re: VBA code does not work on shared workbook

Re: VBA code does not work on shared workbook

Re: VBA code does not work on shared workbook

Re: VBA code does not work on shared workbook

Re: VBA code does not work on shared workbook

Re: VBA code does not work on shared workbook

Thread Information

Users Browsing this Thread

Similar Threads

Timestamp Doesn't Work When Workbook Is Shared

[SOLVED] How do you create a shared workbook so multiple users can work in it at the same time

ActiveX checkbox doesn't work in Excel 2010 shared workbook

Custom Sort Macro Doesnt work when workbook is shared

shared workbook, saving work my multiple users

Deleting activesheets won't work in a shared workbook

Shared Workbook (Workbook Open Code)

Bookmarks

Bookmarks

Posting Permissions