I would like to have a message pop up when a particular worksheet opens
warning users that "All worksheets are linked to Master Price List worksheet.
Please edit only Master Price List."

Is there a way to do this with a macro? Thank you.

This code would go into the workbook's event code segment. To get it there,
right-click on the Excel icon to the left of the word "File" in the menu bar
and choose [View Code] from the list, copy the code, paste it in and modify
as needed.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
'change name as required
If Sh.Name < "Master Price List Sheet Name" Then
MsgBox "your message here"
End If
End Sub


"Ruth" wrote:

I would like to have a message pop up when a particular worksheet opens
warning users that "All worksheets are linked to Master Price List worksheet.
Please edit only Master Price List."

Is there a way to do this with a macro? Thank you.