Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 144
Default Validation List arrow visibility

Hi all,

Is there a way to have the arrows for validation lists be made to be always
visible? The arrow is only visible if a user clicks on the validation cell.

Thanks!

--
Robert
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,480
Default Validation List arrow visibility

Hi

That is the behaviour with Data Validation, the dropdown only appears in the
Active cell.
Debra Dalgleish has information on her site and suggested workarounds.

http://www.contextures.com/xlDataVal08.html#Freeze

--
Regards
Roger Govier



"robs3131" wrote in message
...
Hi all,

Is there a way to have the arrows for validation lists be made to be
always
visible? The arrow is only visible if a user clicks on the validation
cell.

Thanks!

--
Robert



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 144
Default Validation List arrow visibility

Thanks!

--
Robert


"Roger Govier" wrote:

Hi

That is the behaviour with Data Validation, the dropdown only appears in the
Active cell.
Debra Dalgleish has information on her site and suggested workarounds.

http://www.contextures.com/xlDataVal08.html#Freeze

--
Regards
Roger Govier



"robs3131" wrote in message
...
Hi all,

Is there a way to have the arrows for validation lists be made to be
always
visible? The arrow is only visible if a user clicks on the validation
cell.

Thanks!

--
Robert




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
Validation drop down arrow list disappeared Baggins Excel Discussion (Misc queries) 2 June 5th 10 10:24 AM
Data Validation Arrow Color morjayne Excel Worksheet Functions 2 April 16th 08 08:43 PM
Can't delete validation arrow [email protected] Excel Worksheet Functions 1 August 29th 07 03:02 PM
data validation list arrow style John Davies Excel Programming 1 September 29th 05 02:49 PM
Data Validation - Drop-down list - make arrow visible at all times supergoat Excel Discussion (Misc queries) 3 April 19th 05 01:01 PM


All times are GMT +1. The time now is 12:23 AM.

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

About Us

"It's about Microsoft Excel"