Pinaceous
Well-known Member
- Joined
- Jun 11, 2014
- Messages
- 1,122
- Office Version
- 365
- Platform
- Windows
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:
So, How do I change this pop-up to my own creation.
For example:
I've tried what I thought were logical approaches but am not achieving my message box.
Any suggestions???
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???