How do I add a balloon message to a locked cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to add a balloon message to a locked cell to advise other users
that the cell is retricted
 
Data Validation>Input Message and check “Show input msg when cell is
selectedâ€. A balloon will show up at the cell or at the office assistant if
it is active.

Mike R.
 
Insert Comment?

Unprotect the sheet, add the Comment then re-protect.

If using Version 2002 or 2003 you can prevent the user from selecting unlocked
cells.

When Protecting the sheet you will be given a dialog of options to choose
from.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CUMIPMT 0
Project Loon takes to the skies in Puerto Rico 0
Locking A cell determined by data 12
Locking Cells 3
Word Balloons in Word 2010 0
How unlock locked cells 2
Macro / Programming to lock cells 1
Dates 1

Back
Top