Microsoft Office Forums - View Single Post - [Solved] Message Box vba when a sheet is activated

Thread: [Solved] Message Box vba when a sheet is activated

View Single Post

Old

09-28-2022, 02:39 PM

rollis13

rollis13 is online now

rollis13 uses Windows 10

Windows 10 rollis13 uses Office 2016

rollis13 uses Office 2016

Office 2016

Competent Performer

Join Date: Jan 2021

Location: Cordenons

Posts: 140

rollis13 will become famous soon enough

Default

Since you have only three sheets to manage you could use:

Code:

If Sh.Name = "Sheet X" Or Sh.Name = "Sheet Y" Or Sh.Name = "Sheet Z" Then

Reply With Quote