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: 586
Default Double Click Event Error on Worksheet

I have a Worksheet that my users use to quote particular jobs. The entire
worksheet is locked and protected. The only way they can add/edit data is
via a UserForm. When they add a particular product, a cell labeled "Edit" is
unlocked. I have a Before Double Click Event that the user uses to double
click that cell and the UserForm shows up to make edits.

My issue is when there are no products on the worksheet. The entire sheet
is locked and protected. When I double click something an error shows up. I
don't want this to confuse the User. Is there a way to ignore that
particular error, but show other errors for debugging? Or have a MsgBox show
up saying something?

Thanks,
Ryan
 
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
Is there a double click event for cell? Ayo Excel Discussion (Misc queries) 3 June 6th 08 12:18 AM
userform label double-click goes to click event John Paul Fullerton Excel Programming 3 May 19th 06 05:54 PM
Can you capture worksheet double click event from an Add-In???? JGeniti Excel Programming 4 January 23rd 06 07:37 PM
Sheet After Double Click event? Tom Ogilvy Excel Programming 0 July 27th 04 05:59 PM
Before Double Click Event gregork Excel Programming 4 February 9th 04 09:17 AM


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