Protection Question

S

Smoakstack

Board Regular
Joined
Mar 28, 2011
Messages
79
I have a code and works perfectly, but I would like for a MSGBox to come up instead of telling the user that the cells are locked. is there a way to do this? (I do not have code as I do not know where to begin)
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
You must log in or register to reply here.

Similar threads

FloatedWheat
  • Question Question
Protect Sheet with Different User Permissions
Replies
3
Views
563
iggydarsa
iggydarsa
A
  • Solved
Using Cell value in VBA as Password to Open file
Replies
3
Views
103
Kaper
Kaper
A
  • Solved
excel protected sheet - some cells are unlocked for user input getting cleared on click
Replies
3
Views
134
AgentBaadal
A
A
  • Question Question
VBA help - Locking & unlocking on certain times of day
2
Replies
17
Views
456
dmt32
D
R
  • Solved
Msbox VBA code when cell value is changed
2
Replies
18
Views
581
Ramadan2512
R

Forum statistics

Threads
1,224,586
Messages
6,179,719
Members
452,939
Latest member
WCrawford

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top