LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 440
Default Change a default Excel warning

Hi,
Column D is locked when the worksheet is protected but the cells in that
column can be selected. If a user tries to enter text into any of the cells
in "D", the standard warning appears i.e. cell is protected and read only.
The cells can be double clicked which opens a user form into which the user
will enter the data. When that is closed, the data is transferred to the
locked cell by code.
My q is can the default warning message be replaced by one of mine for
instance informing the user to double click the cell?
Thanks.
--
Traa Dy Liooar

Jock
 
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 can I change default row numbers in Excel ? XcelMstr Excel Worksheet Functions 5 April 2nd 23 07:42 PM
How do I change Excel default number? PatrickR Excel Discussion (Misc queries) 3 January 28th 10 05:09 PM
How to change excel 2007 default name maul_pawar Excel Discussion (Misc queries) 1 October 2nd 09 01:38 PM
Change default number to default text? [email protected] Excel Programming 1 April 1st 09 07:30 PM
How do I change the default attribute in excel? worken Excel Discussion (Misc queries) 2 January 31st 06 01:56 AM


All times are GMT +1. The time now is 04:08 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"