Hi Martin,
You could try selecting only visible cells by pressing F5->Special->Visible Cells Only. Regards, Upendra Singh +91-9910227325, +91-9310760597 ---------------------------------------------------------------------------- --------------------------------- There are 10 kinds of people: Those who understand binary and those who don't. ---------------------------------------------------------------------------- --------------------------------- -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Durbat Sent: Sunday, July 26, 2009 3:55 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Clearing data from a protected sheet Hi Hope this makes sense and I'm not posting wrong group but I've failed on something I thought was going to be easy. I have a large spreadsheet into which childrens test scores are added. I have hidden columns which do some analysis of the scores and display the results in an other visible column. I have protected the sheet such that data can be added as the tests are completed but the hidden formula cells can't be amended. My problem occurs when I try to clear a selection of cells which span the hidden, protected cells I get the usual message about unprotecting the sheet first which defeats the objective of trying to prevent accidental erasure of the formulea. Is there any way of "ignoring" the protected cells to allow large portions of data to be cleared quickly? Thanks for any responses Martin --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
