LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default Change Single-Click Functionality?

Hi--

I work for a publishing company whose editors are really comfortable with
Microsoft Word. They're terrified of Excel and avoid it whenever possible.

I'm trying to sell the benfits of Excel to them, however, and am rebuilding
a few forms they've clunkily set as Word tables into Excel as a demo. By way
of trying to mimic Word as much as possible without sacrificing the benfits
of Excel, however, I was wondering if there's VBA code I can use to change
Excel's single-click function so that, whenever a user clicks on an unlocked
cell, an editing cursor immediately appears (as opposed to Excel's default,
where you need to double-click on a cell to to in-cell edits).

Most of the cells (espcially those with formulas) are locked, so that the
only unlocked ones are those calling for text input of one sort or another.
Is what I want to do even possible?

Thanks for any help anyone can offer!

 
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
Custom Right Click Menus - Inconsistent Functionality Lee Excel Discussion (Misc queries) 1 February 3rd 07 03:41 AM
Changing row content with single cell click aussiemike Excel Discussion (Misc queries) 2 May 25th 06 06:37 AM
change value with single click, increasing by 1 every time? jkbrown Excel Discussion (Misc queries) 3 May 4th 06 12:49 AM
Running of Worksheet Change Macro breaks undo functionality. Rob Manger Excel Discussion (Misc queries) 1 April 6th 06 04:04 AM
How to restore right click functionality for copy and paste? duncansk Excel Discussion (Misc queries) 3 August 11th 05 12:39 PM


All times are GMT +1. The time now is 09:37 PM.

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"