LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
FC FC is offline
external usenet poster
 
Posts: 130
Default HOWTO DELETE UNLOCK CELLS

I'm looking for a way to delete unlocked cells in a worksheet without using
formulas,macro... This is the thing : locked cells are written and don't
change,
unlocked cells are to write on them, print and erase the context to write
again of course.Also the sheet is protected with the purpose of keeping the
locked cells with the text that does not change. My 2 options :1- copy the
worksheet with the empty unlocked cells and write in them everytime in
different sheet or 2- do what I call tab-delet, tab-delete, tab-delete until
all unlocked cells are deleted ( effective but long proccess). Is there a
better 3er options or I'm asking too much from excel ?TX.
 
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
Lock/Unlock cells BFife Excel Worksheet Functions 2 October 25th 06 03:20 PM
how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. Daniel Excel Worksheet Functions 1 June 24th 05 02:59 PM
How do I unlock specific cells in a spreadsheet that I protected? onemanhattanrebel Excel Discussion (Misc queries) 1 May 8th 05 04:54 PM
How can I unlock the grouping in Excel while locking cells? f Excel Discussion (Misc queries) 0 April 27th 05 03:50 AM
Lock and Unlock cells using VBA Peter Excel Discussion (Misc queries) 1 January 29th 05 02:00 PM


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