## Locking worksheet labels and box sizes

MS EXCEL

### Next

• 1. How do I limit the number of complete sentences in a spreadsheet c
I'm trying to keep the number of complete sentences to the maximum number within a 400 character limit. I understand how to use LEN to limit the number of characters, but don't get how to take the resulting cells that have incomplete sentences and delete the partial sentence at the end. Any advice would be appreciated.
• 2. Setting up a spreadsheet to calculate apportionment of service cha
On the sale of a leasehold property, service charge and ground rent are payable at X per annum from the start of the accounting period - Y - to the end of the accounting period - Z. If completion of a sale - A - takes place on a date between Y and Z, I need to set up a formula on an Excel template (using Office XP) to enable me to calculate the balance of money due back to the Client from A to Z. I have been working it out on paper as X divided by 365 to get the daily rate, multiplied by the number of days from A to Z. To complicate matters, not all the accounting periods start and end with the same dates, the months all have a different number of days in them and as a complete novice to Excel, I just can't figure out how to do it but feel that it ought to be possible. Any pointers would be humbly and gratefully appreciated.
• 3. what is the maximum columns I can have on an excel workbook
I want to creat 1000 columns in one Workbook, how do I perform the task, and is there a limit to the Columns I can get in one Workbook. It has to be in one workbook. Thanks
• 4. Is military time available in Excel? If so, how would I calcu
basic spreadsheet as follows: 0800 start time, 1200pm end time, total time These blocks of time represent jobs, and there will be 4 jobs on one sheet. thanks. how do I format the cells (i.e., by number, time, general) "Peo Sjoblom" wrote: > What is military time? Like this? 600 1000 2400 etc? > If so > > > =MOD((INT(B1/100)+MOD(B1,100)/60)/24-(INT(A1/100)+MOD(A1,100)/60)/24,1)start > time in A1 and end time in B1 > -- > Regards, > > Peo Sjoblom > > (No private emails please, for everyone's > benefit keep the discussion in the newsgroup/forum) > > > > "TimP" < XXXX@XXXXX.COM > wrote in message > news: XXXX@XXXXX.COM ... > > if military time is available in Excel, how would I calculate sum? > > >
• 5. make multiple copies of a sheet in a new workbook
I am using excel 2003 and I need to make 29 copies of one sheet form a workbook to another all at once. Does anyone know of a way to do that?

### Locking worksheet labels and box sizes

```I made an application in Excel 2007 for my clients to fill out with drop down
boxes.  I want to be able to lock the size and the labels on the application,
but still let me clients use the drop down boxes and type in informaiton in
appropriate places.  Everytime I try to lock it locks the whole sheet so they
can't use the drop down boxes.
```

### Re: Locking worksheet labels and box sizes

```=?Utf-8?B?TXVuY2hraW4=?= < XXXX@XXXXX.COM > wrote in

by default, all cells are check marked as "locked"
- right click on your cell (or range of cells)
- click format cells...
- the last tab is protection
- just uncheck the unlock

then when you go back into protect the sheet, you want to uncheck unlocked
cells.
hope that helps
```

```Hi, I am creating a form, which reads depending of a choice from an excel
worksheet the value for label caption, right next to this label a textbox is
shown. Because the size of the label caption is dynamic, the position of the
textbox must shift left or right on order to read the complete label caption.
By doing so the size of the form might also need to change. How to create
such? there are 10 possible labels and textboxes, which are shown depending
on the choice. This last part is already working.

Regards
Gerard
```

```Jacob,

Thx

Gerard

"Jacob Skaria" wrote:

> Try setting the below property of Label
>
> AutoSize property to True
> OR
> WordWrap property to True
> --
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "noord453" wrote:
>
> > Hi, I am creating a form, which reads depending of a choice from an excel
> > worksheet the value for label caption, right next to this label a textbox is
> > shown. Because the size of the label caption is dynamic, the position of the
> > textbox must shift left or right on order to read the complete label caption.
> > By doing so the size of the form might also need to change. How to create
> > such? there are 10 possible labels and textboxes, which are shown depending
> > on the choice. This last part is already working.
> >
> > Regards
> > Gerard
```

```The text that I type into the y-axis label is always cut off. For example, I
would like the label to say:

Cell density
(cells/cm2)

Cell densi
(cells/cm

I cannot get around this problem by choosing a smaller (or even larger) font
or by turning a long one-line entry into two lines of text.

I just upgraded to Excel 2003 Small Business Edition. This did not seem to
be a problem with Excel 2000.

Thanks,
Jen
```

```Hello,

I am trying to automate Word (needs to be downward compatible to Word 2000,
so I'm using msword9.olb library) to do a mail merge to mailing labels.

I'm using VC++, but I've also tried this with VB, and the same problem
occurs.
I have directly put in the code found in article 258512, and the same
problem occurs... so this should be easy to reproduce.

The problem is this:

When I create the mailing labels using automation, it creates a gigantic
page of 11.22" x 12.05" size.  The margins are all wrong, too.
I am trying to create a standard Avery 5160 label, and I pass in the code:

oNewDoc = oMLabel.CreateNewDocument( COleVariant( "5160"), vtOptional,
vtOptional, vtOptional, vtOptional);

And what I get in the end is a large page full of labels 4 across and 12
down.  I tried to change the page size directly, but the labels is still 4
across and 12 down, which means it's not really Avery 5160.

I tried the equivalent in VB using Word 2007 type library, and I got the
same result.

My data source is a comma-delimited text file, but that shouldn't matter...
the merging is fine.  It's just that the page size and the margins are all
wrong.

If you have any idea what is going on, and what I can do to fix it, I would
appreciate it very much.

Thank you.

--Daniel

```

```Good afternoon --

I would like to set up a combo box using the labels of the worksheets as the
options from which the user selects.  So, if I had a contiguous set of
worksheets -- Smith, Jones, Thompson, for example -- how could I do that?

Can anyone help with how to do that?