View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How to tell if a cell is protected

<on others is does not.
What does that mean? What happens? You do something (what exactly?) and Excel does (how?) or does not react. What exactly happens?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Barry.Robertson" wrote in message
...
|I have nine workbooks I have combined into one workbook using the
| drag-and-drop system as described by Bernard Liengme on 11/25/07. All the
| workbooks were single worksheet's that my company uses as forms for personnel
| files. I don't want to reinvent the wheel, but I am trying to make some of
| the work easier.
|
| What I am doing is setting up all the worksheets to autofill the redundant
| information on each sheet, i.e. name, address, phone number, etc. I am using
| the formula "=sheet!cell". It is working on some sheets and on others is
| does not. On some of the sheets, only certain cells won't accept the formula
| while others work just fine.
|
| So, my question is: are some of the cells protected on a different level
| than the usual sheet protection and locks (under formatting), and if so,
| where do I view that information?
|
|