UnLocked Cells No Color
I have a spread sheet which is passed around frequently. Therefore I have locked a number of cells to protect its information. However, its necesary that other change the color of the unlocked cells.
The problem is that once the sheet is protected the unlocked (and therefore changeable) do not have any color icon and so I cant change them. I cant figure out a way to have locked cells and still allow color changes on the unlocked without giving the password away (which of course defeats the purpose)
This capability was added in xl2002.
But if you're running an earlier...Word 2007 opens very slowly
When I try to open word 2007 by clicking on any document, it takes up to 2
minutes to load the program. If WORD 2007 is already open, then documents
that I click on open right away. This just started happening recently. I
have had WORD 2007 for several months without this problem.
...Composite USB Virtual COM port and HID keyboard on Windows 7
I made a composite USB with Virtual COM port and HID keyboard. It works fine on W2K/XP/Ubuntu, but it does not work on Windows 7. I've tried everything, but nothing works (This device cannot start. Code 10).
To make things worse, Windows 7 is too dumb to recognize the HID keyboard, which does not happen in XP/2K (they recognize the HID keyboard, even without a CDC .inf).
Thanks in advance. yandiz <email@example.com/> wrote:
>I made a composite USB with Virtual COM port and HID keyboard. It
>works fine on W2K/XP/Ubuntu, but it does not work on...video footage in excel or word
I am embedding video footage into excel but when I email the file the footage
isn't attached. I believe this is because you are unable to fully embed the
footage like you can with say clip art, however, the person I am doing this
work for insists it is possible - can anyone help? Is is possible to do it
in Word instead?
...publisher 2007 has changed its design to what looks like word?
my publisher that iv got on office 2007 has changed its design on its own. it
went from looking nice and modern, like office 2007 does. but when you click
on a template it only gives you the options that word has and looks old
Publisher does not have the ribbon. Publisher never has looked like Word.
"chloe" <firstname.lastname@example.org> wrote in message
> my publisher that iv got on office 2007 has changed its design on its own. it
> went from looking n...Fill Color with Keyboard Function
Is there a Key Combination that will fill the selected cell with the color
that is selected on the pallet...as opposed to having to mouse to the pallet
at the top of the workbook????
No, there is no such keyboard shortcut. And, as far as I know,
there is no programmatic way to determine what color is the
current pallet color.
"Matt Cromer" <MattCromer@discussions.microsoft.com> wrote in
> Is there a Key Combination that will fill the selected cell
> with the color
> that is selec...Keyboard Shortcuts #2
I would like to know where I can find the list of Keyboard shortcuts for GP.
Go to Help>Index and type in 'keyboard shortcuts'.
GP 9.0, SP2
> I would like to know where I can find the list of Keyboard shortcuts for GP.
You can find the list in the System User's Guide under Help > Printable
Manuals > System.
Dynamics GP MVP
Flexible Solutions, Inc.
"Andy" <Andy@discussions.microsoft.com> wrote in message
>I would like to know...Office 2004 for Mac: Word
Somehow my standard toolbar has disappeared in Word and it will not
come back even if I check it in the view; toolbars; standard menu and
still it won't come back. Please help!!
In article <email@example.com>,
> Somehow my standard toolbar has disappeared in Word and it will not
> come back even if I check it in the view; toolbars; standard menu and
> still it won't come back. Please help!!
Try selecting the Standard toolbar in Tools/Customize/Customize
Toolbars/Menus (so that the name is highlighted, not...how do i unlock modifications
My Word 2007 used to work. Now I can't do ANYTHING on it because it tells me
the modification I am trying to use is locked. How do I unlock it?
Are you using a trial version of Word that has passed its use by date? If
so, to see how to convert it to a regular version, see "How do I convert my
Another possibility is that you have not Activated the software. You can
also find out how to do that at the above site.
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
...Outlook Word editor
When Outlook is configured for Word as default editor in
new messages, my MAPI device opens Outlook email message
in the Outlook editor.
Can you keep Publisher 2007 from breaking a specific word?
Turn off hyphenation in Options, edit tab. You can change the spacing in the
font (format, character spacing).
Mary Sauer MSFT MVP
"lindalou" <firstname.lastname@example.org> wrote in message
> Can you keep Publisher 2007 from breaking a specific word?
Does that mean that there will be no hyphenation in the entire document, or
can you do it just for specific wor...Slow to Open Excel (& Word) 2007 docs
Thanks to anyone who can help.
I have read many threads regarding this matter, both within these discussion
groups and other forums too. All suggestions have failed in our environment.
Basically, Excel and Word documents are slow to open in Office 2007 when
opened via (for example) double click. They are not slow to open when opened
via the open dialog mechanism via the Office 2007 button. This is not a file
size, network or antivirus issue. The same problem exists when trying to open
a very small file from (for example) a file copied to the local desktop with
antivirus software comple...Selecting Unlocked Cells Only
Is there a way in VBA to have user restricted to selecting only unlocke
cells in a work book. I have tried to password protect each work shee
with the cells formatted as locked or unlocked. However when you sav
and reopen the workbook "sometimes" it reopens allowing the user t
select both locked cells as well as unlocked cells. The locked cell
are still restricted, so if you click on it you get the warning...bu
it's a pain if you're trying to imput data quickly navigating aroun
all the cells on a work sheet
---------------------------------------------------------...Open embedded word document in powerpoint presentation
I have powerpoint 2007
I want to open embedded word document while doing presentation, without
going into the edit mode.
How can i do this?
Somebody adviced in other thread to right click mouse and select action
settings on top of the embedded file. There is no such menu in 2007.
On Feb 19, 4:53=A0am, Poppe <Po...@discussions.microsoft.com> wrote:
> I have powerpoint 2007
> I want to open embedded word document while doing presentation, without
> going into the edit mode.
> How can i do this?
&g...How do I merge a Word document into Publisher?
I am using Publisher 2000 for the first time. I have a four-page Word
document that I need to print "brochure style" or folded card style on 11 X
17 paper. The document has a lot of text boxes and complicated formatting.
How do I tell Publisher to simply copy the pages in the right places?
Open the Word document, open Publisher, Copy, Paste.
"Denise" <Denise@discussions.microsoft.com> wrote in message
> I am using Publisher 2000 for the first time. I have a four-page Word
...Compare 2 columns with words to 1 and to get the 3rd word.
I have question for you. I have letter "h" (from high) in column A1 and
letter "L" (from low) in column B1. In column C1 i would like to get the
avarage from them which is "m" (from Medium). How to do it?
Thanks in advance
Put this formula in C2:
and copy down as required.
Hope this helps.
On Mar 9, 9:12=A0am, Postman <Post...@discussions.microsoft.com> wrote:
> Hi All
> I have question for you. =A0I have letter "h" (from high) in column A1 an=
> letter "L" (fr...Clearing Form Content in Word 2007
Does anyone know how to clear the contents of a form in Word 2007?
Create the form as a template and then use File New and select that template
each time you want an empty form.
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.
"caehgar" <email@example.com> wrote in message
> Does anyone know how to clear the contents of a form in Word 2007?
...Apple Iphone Unlocked,HTC Google Nexus Unlocked
We are a Recognized Distributor of Various Consumer Electronics, We
Specialize in a wide Range of Products such as Mobile Phones, Laptops,
Video Games Console, Digital Cameras, (Etc) At Affordable Prices.
This phones are unlocked and can be used with any SIM card. No
This phones are brand new original with complete accessories,
accompanied with 12 month international warranty.
Contact us today for your order at our marketing email :
Email : firstname.lastname@example.org
Apple iPhone 3GS 32GB��.$240
HTC Google Nexus One����$200
Nokia N97 .......My selections are locked--how do I unlock them?
I'm using Microsoft Office Home and Student 2007 and the bottom of my page
says that my selections are locked. This happens when I try to do anything.
The only thing I can do is open a document, but it won't let me type or copy
or anything like that.
Also, little paragraph symbols have appeared all over my page.
Is it a trial copy that has expired? If so, time to buy.
Is it a retail copy that hasn't been actived?
"ChikiMongo" <ChikiMongo@discussions.microsoft.com> wrote in message
: I'm...New G5 tower has problem opening Word 2004
I have a brand new G5 running OSX 10.4.10. I have installed Office 2004, and am having trouble launching Word. After double clicking, it opens a blank window and then freezes as it works it way through the "optomizing font performance" bar at the bottom of the window. <br><br>It starts to give me a warning box for one font after another that says "This font is corrupt and should be removed." I believe, however, that Word itself it installing the fonts in Font Book just before it determines they are corrupt. Wierd. <br><br> It has taken me over 1/2 ho...Unlocking Cells
Hi, I'd like to know if there's a simple way to unlock or lock cells.
I'm not sure if "Lock" is the correct term here. For example, if you
have a formula that has C$14. Is there an easy way to unlock (remove
the "$") from the formula or to ad it without manually doing it?
Thanks for your help!
You can use a macro to change the reference style (absolute vs relative), but
you can also do it manually.
Select the portion of the formula (just a single cell reference or the entire
formula if you want) and hit the F4 key to cycle through all 4 options.
lj ...Merging Protected word documents.
I have 3 Protected word documents that I would like to
have in 1 document. I cannot get them to keep their
individual spacing ad margins when I import the
documents. How can I do this?
...any method of keyboard remapping?
Any method of keyboard remapping In Excel?
What do you want to do? "remapping" is a loose term. HTH Otto
"Ron" <Ron@discussions.microsoft.com> wrote in message
> Any method of keyboard remapping In Excel?
> Any method of keyboard remapping In Excel?
The only way I'm aware of is by assigning short-cut keys to macros.
However, a Windows keyboard remapper utility may help you. Do a Go...Scanning into Word 7
With word 2002 I was able to quickly scan anything into the document by going
to INSERT, PICTURE, SCANNER, which opened my scanner program.
Where is this option in word 7?
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
...Unlock [all]? or unlock [associated]
I currently use OneNote 2007.
With SEARCH capability, I often am faced with the message "x amount found, y
amount in locked notebooks that must be unlocked to view."
Well, that sounds great.
Until, that is, you are faced with 100 sections you have to unlock- not
knowing which ones contained the information means you have to unlock each.
One Note SHOULD allow a user to:
1) Unlock All locked notebooks (Perhaps with a master password.)
2) Unlock associated sections / notebooks (If you have two passwords,
entering one will unlock all of the notebooks that use that passwor...