LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 747
Default Function is not available on a protected worksheet

I forgot to answer the below question:

The strange thing is, when I comment out the entire code, I still get
the error.


I beleive this is because the normal function of double-clicking a cell is
to enter Edit Mode. This is not allowed for locked cells when the sheet is
protected. Therefore, this should cause an error message whether you had
created code or not. However, I wouldn't expect you would get the same
message. Rather, somthing to the effect that you can't change protected
cells. I get:

"The cell or chart you are trying to change is protected and therefore
read-only..."

Regards,
Greg
 
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
Can I use the subtotal function while a worksheet is protected? Michelle Thompson Excel Worksheet Functions 0 November 30th 09 06:15 PM
Using solver function in a locked (protected) worksheet Niels Excel Worksheet Functions 2 November 16th 09 09:55 PM
Using Spell Check function in text box when worksheet is protected Paul Excel Discussion (Misc queries) 0 February 8th 07 04:29 PM
Tab Function in Protected Worksheet TRM Excel Discussion (Misc queries) 1 September 27th 06 07:37 PM
Group Function on a Protected Worksheet CiaraG[_4_] Excel Programming 1 December 22nd 03 04:46 PM


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