Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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!

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default Change Single-Click Functionality?

It can be done, but to my mind shouldn't be done. Put the following in the
ThisWorkbook module.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
If Sh.ProtectContents = True Then
If Target.Locked = False Then
SendKeys "{F2}"
End If
Else
SendKeys "{F2}"
End If
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Wuddus" wrote in message
...
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!


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default Change Single-Click Functionality?

Thanks for the reply, Chip! I've referred to your Web site often over the
years, so it's a little like getting a reply from, say, Tom Cruise or
something.

Anyway, I agree it shouldn't be done. I like the protection that
double-click in-cell editing provides, but unfortunately I'm in the minority.
I'm afraid, though, that I don't think this method will work for me. Almost
everyone in Editorial is on PC, but a few of them are on Mac, and I don't
think SendKeys works on both platforms. (At least, that's what the help
system on a Mac told me this morning when I tested the procedure on it.)

So probably I'm just screwed on this poin,t unless you have any other ideas.
Sorry I didn't mention the PC/Mac thing in my email. Most of the time it
doesn't really effect how we use Word and Excel, but in this case it does.
Sigh.

I truly appreciate the suggestion, though!

"Chip Pearson" wrote:

It can be done, but to my mind shouldn't be done. Put the following in the
ThisWorkbook module.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
If Sh.ProtectContents = True Then
If Target.Locked = False Then
SendKeys "{F2}"
End If
Else
SendKeys "{F2}"
End If
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Wuddus" wrote in message
...
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!


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


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