Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default Help with lockiing/unlocking cells in subroutine


--
Hugo
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,939
Default Help with lockiing/unlocking cells in subroutine

locked
Range("A1:A10").Locked = True
unlocked
Range("A1:A10").Locked = False

I am sure that this is not what you are looking for but I have alread put
more time into my answer than you put into your question. In the future be
specific with what you want.
--
HTH...

Jim Thomlinson


"Hugo" wrote:


--
Hugo

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,071
Default Help with lockiing/unlocking cells in subroutine

Hugo
Record a macro to get the code for locking and unlocking a cell. If you
need more, provide information about what you are doing. HTH Otto
"Hugo" wrote in message
...

--
Hugo



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
Unlocking cells maltagirl Excel Discussion (Misc queries) 3 June 16th 08 07:20 PM
unlocking cells johnsail Excel Programming 12 April 6th 08 10:21 AM
Unlocking cells Vanilla Skies Excel Worksheet Functions 1 September 25th 06 04:30 AM
Unlocking Cells Sisilla Excel Programming 1 July 18th 03 08:58 PM
Unlocking Cells Tom Ogilvy Excel Programming 0 July 18th 03 08:46 PM


All times are GMT +1. The time now is 07:11 AM.

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

About Us

"It's about Microsoft Excel"