Morning All,
Thought I had all my macros nailed but when I shared the workbook I got this error "This command is not available on a shared workbook".
The Macro was triggered upon selecting "Yes" from a data validation list and this is the macro.
It calls another macro but think the problem lies with this script although can't be 100% certain.
Any advice please?
Thanks =D
Thought I had all my macros nailed but when I shared the workbook I got this error "This command is not available on a shared workbook".
The Macro was triggered upon selecting "Yes" from a data validation list and this is the macro.
VBA Code:
Option Explicit
Option Compare Text
Private Sub Worksheet_Change(ByVal Target As Range)
Dim OldValue As String
Dim NewValue As String
' don't trigger any events if user is making some sort of change to multiple
' rows or columns simultaneously
If Target.Cells.Count > 1 Then Exit Sub
If Target.Column = 1 Then ThisWorkbook.Save
If Not Intersect(Target, Columns("F")) Is Nothing Then
If Target.Value = "YES" Then
Call Create_Project_Board(Target.Row)
ThisWorkbook.Save
End If
End If
It calls another macro but think the problem lies with this script although can't be 100% certain.
Any advice please?
Thanks =D