Search:

You should enable the option to automatically create a drawing canvas.

Cheers
Geof

Hi
I am using office 2010 ..

I still select multiple objects with the shift +click as I did.
Then a right click and select grouping from the pop out menu.

I have noticed that I cannot select...

Hi

Is there a reason you stopping you using the built in command Data>.Advanced Filter>

In this way you would not need any code at all.
The Criteria Region would have separate rows for each...

Hi
This might be a pointer

Sub pauseForName()
dim sNewName as string
sNewName = InputBox("Type new name")
MsgBox sNewName
End Sub

There is still a bit of work to do.

Welcome to the weird wacky world of word outline numbering.
You need to forget about direct formatting via Bullets & numberin dialog.

Best I can do is direct you to an article by one of the Word...

Hi
I have heard of something similare once before ..

the cause was due to exceeeding a max allowable number of cell formats.

At that time the user was in the habit of formatting entire...

Hi Chuck
Try beginning the section with the narrow margins with a continuous sectnbreak that follows immediately after the next page section break.


next page sectn brk
continuous sectn break...

Hi
In the screen capture C2 contains the formula
=DATE(YEAR(A2),MONTH(A2)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A2),MONTH(A2)+1,0),2)-5))

D2 contains the formula...

Hi

Word 2007/2010
Locate and edit normal.dotm to remove the text.
Save and close

Word 2003 or earlier
Locate and edit normal.dot to remove the text.
Save and close

Hi

Investigate the use of range.calculate.

example: selection.calculate

Hope it helps

Geof

Hi there
You are having an issue with Absolute vs Relative cell addressing.
The format with $ symbol is known as Absolute.
This is a critical concept to master.

Edit a formula.
Place cursor...

Hi Ceceilia
I created a form with a text box to store the path to the pic.
Important that I included the double slash in pathname

The OK click created the docVariable and populated it with...

Hi
Adding hypens
The addition of a hyphen creates a mix of alphabetic and numeric characters. ie. the entry is no longer a number so no arithmetic.

This would be analogous to a phone number...

Hi
Did you manage to do this?
Geof

Hi

To choose the default file format go to

FILE>>Options>>Save


Cheers
Geof

Hi
Thanks for the feedback.
We have both learned something. I enjoy reading the posts and had forgotten about the Autoformat.
I love this lounge for that very reason.
Lounge members have helped...

Hi Sooze

Shauna's site is an excellent resource. Have a good look at her document on creating and linking levels to styles for numbered headings in 2010.

I rarely base my documents on normal...

Hi Sooze
The sample text I used is based on a template which is not associated with my regular 'Normal.dotx' IT is a generic raw Word created template.

The difference is in the line spacing
...

Hi

I achieved this somewhat differently.

A button click includes these lines of code

sFile = get_docRepository & Forms!frmContactEdit!frmContactDocSub!DocFileName...

Hi
I have just tried this on Access 2010
I made a form containing 2 text fields
I named one textDate and populated it with 2011
Using the immediate window I typed
?...

Hi Corden

I assume that you have purposefully rejected option to export/archive using the inbuilt tools.

Check this for some ideas http://support.microsoft.com/kb/290792

Cheers
Geof

Hi
You might try and use the date function.

In an adjacent col

=date(cellRefContaining2005,1,1)

Format the result as date.

Cheers

Thanks anyway.
I guess I will do it the hard way. Progressivley tighten security until common logons cant use it and then back off.

G

Hi

Dave Rado saved my hide years ago with his utility at his mvps site. This enabled backup and restore of autotext entries.

http://word.mvps.org/faqs/customization/exportautocorrect.htm
...

Hi Chuck
I remembered that autotext entries were stored in .acl files as well as in normal. (Some bad experience losing some data when some staff migrated to office 2002 or 03 way back when ?)....