Run macro on Shared Workbook

[danallamas]

I have this code and I was able to properly execute it but the problem is I couldnt seem to get it to work when I enable the shared workbook. The file that I am working on is going multiple users. Is this possible?

Application.ScreenUpdating = False
Sheets("Dumpsheet").Visible = True
Sheet2.Unprotect Password:="abc"

Range("N4").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("Dumpsheet").Select
Cells(Application.Rows.Count, 1).End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
Range("A3").Select
Sheets("Tracker").Select
Range("E2").Select
Application.Goto Reference:="DeleteData"
Selection.SpecialCells(xlCellTypeConstants, 23).Select
Application.CutCopyMode = False
Selection.ClearContents
Range("A1:B1").Select
Range("B1").Activate

Sheets("Dumpsheet").Visible = False
Application.ScreenUpdating = True
Sheet2.Protect Password:="abc"

[MarvinP]

Hi,

When you have VBA code it goes along with the workbook it is stored in. When you ask if your VBA can work on a "shared workbook", I don't know if you own that workbook and it is running on your machine.

Is the Shared Workbook on OneDrive and being shared using the cloud? If that is true then VBA only works on the Excel file on your machine. The OneDrive Cloud view of the Excel workbook is really in your browser and only has simple Excel formulas behind it. If you are trying to run your file VBA code on a shared workbook that lives on the cloud you will need to bring it down to your machine before the code will work on the workbook.