Office Assistant Switch

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

Guest

I have a form that makes heavy use of cell validation.
When the Office Assistant is active, the validation messages appear next to
the assistant. Some users do not readily associate these messages with the
current cell. When the assistant is not active, the messages appear next to
the current cell, which of course, works much better. What I would like to
do is include some VBA code to test for the presence of the Assistant and
disable it, if it is present.
Does anyone know what this code would be?
Thanks
 
Or you can write specifically in the validation message box something
like" IN THIS CELL please enter....." so now the users can be sure the
help refers to the curent cell even though the help message comes from
the help assistant.
 

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

Excel VBA to move cells to sheet2 based on selection in sheet1 0
Office assistant 4
Office Assistant and Balloons 4
Check Box and Validation of a cell 2
Meet Mycroft: An Open Source Virtual Assistant 3
How do i reference an external workbook for data validation? 2
Data Validation in another sheet 1
Summary Worksheet. 1

Back
Top