"Mircrsoft Excel" their pop-up, how do I change that?

[Pinaceous]

Hi Everyone,

I have a protected sheet1 where the user pastes into this sheet1 a set number of cells.

When the user starts off in the wrong column and begins to paste their cells Microsoft Excel produces the following error message:

Mircrsoft Excel
The cell or chart you're trying to change is on a protected sheet.
To make changes, click Unprotect Sheet in the Review tab(you might need a password.)

So, How do I change this pop-up to my own creation.

For example:

MsgBox ("Please make sure that you are in Column B when pasting! Thank you!")

I've tried what I thought were logical approaches but am not achieving my message box.



Any suggestions???

 

[James006]

Hi James006,

I really like your approach and appreciate it:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("B2:D10")) Is Nothing Then MsgBox "Hello"
End Sub

Thank you!
-Pin

Glad this is helping you out ...

Thanks ... for your Thanks ...

 

[Jaafar Tribak]

Hi guys,

Sorry for the delay ... I got hold of a 32bit OS machine only yesterday.

Anyway, I started a new thread on the dll subject .. Take a look here:
https://www.mrexcel.com/forum/excel...uilt-protected-worksheet-warning-message.html

 

[Pinaceous]

Hi Jaafar,

Thanks for reposting!

I'm going to take a look at it!

-Pin

 

[Pinaceous]

Hi Jaafar,

I have a question about your codes that you posted here.

The ones posted for the 32 and 64 bits.

I'm using the 32 bit for excel code and sometimes I'm getting a Microsoft VB Run-time error '1004': MsgBox popup:

You cannot used the command on a protected sheet. To use this command, you must first unprotect the sheet (Review tab, Changes group, Unprotect Sheet button). You may be prompted for a password.

Where, I'm using different workstations with other users on a shared drive, if this helps add any information to your thoughts.

Any thoughts??

Many thanks,
Pinaceous