1) I know you can “name” a cell (name box left of formula bar) and this name remains with that cell anywhere it may be positioned
*the above mentioned for example only.

Question:
Quite often I have to go into my spreadsheet and add various products (rows) to the several categories. I unlock the entire spreadsheet make all of my alterations then relock the entire sheet. I then go through and unlock the few cells that need to remain unlocked.

Can a cell be “marked” in a way as to make it remain unlocked? So when I lock the entire spreadsheet, regardless, these “marked” cells remain unlocked.

2) Can anyone point me to a post dealing with “autosizing” – independent of resolution (so my application will look the same regardless of an employees screen resolution?)

*********************
On a lesser issue – just for my knowledge – when dealing with custom commandbars in VBA, when a commandbar is created and added to the Toolbar menu - unless it is deleted and recreated after any changes to the VB code – the changes made will not materialize, it lives on the code it was created with. My question: where is the information the toolbars use kept? Is this code kept internal after their creation?
*********************
Thank you,
Sam

1. Protecting Cells
By default, every cell has the lock on but it has no affect until protection is applied. If a cell is unlocked and protection exists it will allow the user to edit the cell. So just leave the cells unlocked (format-cells-protection tab).

2.Screen resolution
This is for an Excel alumni! Dont know sorry

3. Custom Commandbars
To me its just like where you create a macro then assign a buton to it. Because you have told Excel that a macro is assigned to the button, it will run the macro thats behind it when you click it. if you create a custom menu, then whatever function youve put to that option will happen. If you just created the menu with no function behind it it would just sit there and look pretty These custom bars can be permanent (changes will remain for all workbooks) or just appear for that particular workbook.

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the
Terms of Use
Excel is a registered trademark of the Microsoft Corporation.MrExcel is a registered trademark of Tickling Keys, Inc.