Multiple message boxes for each locked cell in the same worksheet

**Justair07** · 01-08-2013, 04:33 PM

Hello,

Excuse my poor discreption of my issue but I'm new to VBA.

I have 3 diffrent groups of locked cells that are all locked for a specific reason. I would like to know if it is possible to create a message box for each individual group of locked cells to explain it's security?

I was able to create a message box to replace the default Excel alert for when a locked cell is selected but i'm not sure how to make multiple messages for multiple locked cells.

Hope this makes sense.

Thanks a bunch,

**Bishonen** · 01-08-2013, 04:40 PM

Please Login or Register  to view this content.

This goes into the module of the worksheet in which the cells are locked.

if this works, add another ranges and just adjust the rest of the code

**Justair07** · 01-08-2013, 04:49 PM

Awesome!! Thank you Bishonen, worked perfect! But how did you know I was Batman?

Multiple message boxes for each locked cell in the same worksheet

LinkBack

Thread Tools

Rate This Thread

Display

Multiple message boxes for each locked cell in the same worksheet

Re: Multiple message boxes for each locked cell in the same worksheet

Re: Multiple message boxes for each locked cell in the same worksheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions