Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to change Template Comments/Tips?

I am using Excel 2003. I am using the Expense Statement Template which comes
with Excel. This template contains comments or some sort of tips when you
click on certain cells. On this particular template there is a section
called "Offical Use Only". When I click on one of the cells in this area, I
receive a pop-up or comment/tip which explains the use of these cells. How
can I change, delete, or modifiy the contents of these comments/tip?
Respectfully, Scott Loga
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to change Template Comments/Tips?

I found the answer. It is under Data/Validation.

Regards,

Scott Loga

"Scott Loga" wrote:

I am using Excel 2003. I am using the Expense Statement Template which comes
with Excel. This template contains comments or some sort of tips when you
click on certain cells. On this particular template there is a section
called "Offical Use Only". When I click on one of the cells in this area, I
receive a pop-up or comment/tip which explains the use of these cells. How
can I change, delete, or modifiy the contents of these comments/tip?
Respectfully, Scott Loga

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How to change Template Comments/Tips?

Scott

Those pop-ups are Data Validation messages.

First go to ToolsProtection and Unprotect Sheet.

Next, click on the cell and DataValidation. Change the input message.

OR just "Clear All" to delete.


Gord Dibben MS Excel MVP


On Tue, 12 Sep 2006 14:39:03 -0700, Scott Loga
wrote:

I am using Excel 2003. I am using the Expense Statement Template which comes
with Excel. This template contains comments or some sort of tips when you
click on certain cells. On this particular template there is a section
called "Offical Use Only". When I click on one of the cells in this area, I
receive a pop-up or comment/tip which explains the use of these cells. How
can I change, delete, or modifiy the contents of these comments/tip?
Respectfully, Scott Loga


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the $ currency symbol in a balance sheet template Dave Excel Discussion (Misc queries) 1 November 20th 05 04:31 PM
How do I change a template (mall) in Swedish Excel gregor Excel Discussion (Misc queries) 3 May 6th 05 03:55 PM
How to change $ to £ in pre-formatted "Expense Statement" template Ardnanrigh Excel Discussion (Misc queries) 6 February 4th 05 10:09 PM
how do i change the expense statement template macro Mad2691 Excel Worksheet Functions 1 January 28th 05 01:21 PM
automatically change nvoice # on template jerome keays Excel Worksheet Functions 1 January 15th 05 07:14 PM


All times are GMT +1. The time now is 08:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"