Allow comments to be added to protected worksheet?
I have created a worsksheet with selected areas locked and then protected it.
My users want to be able to add comments where necessary but are not able to.
I cant seem to find anything in the help menu - any ideas?
When protecting the sheet "allow users to:"
Select unlocked cells and Edit Objects.
Note: with edit objects checked, users can insert comments in locked cells
if they are allowed to select those.
Gord Dibben MS Excel MVP
On Wed, 4 Nov 2009 15:00:02 -0800, sue@solotel
>I have created a worsksheet with sel...Moving license to a new computer
I bought a powerbook and am giving the kids my old imac. I'd like to
move Office to the powerbook and remove it from the imac. Am I going
to run into any technical difficulties doing this?
In article <firstname.lastname@example.org>,
Andrew D <email@example.com> wrote:
> I bought a powerbook and am giving the kids my old imac. I'd like to
> move Office to the powerbook and remove it from the imac. Am I going
> to run into any technical difficulties doing this?
Shouldn't. Run the Remove Office application on the iMac, and inst...Word wrap in excel?
Is there word wrap functionality in excel?
If in cell A1 I have a string of text say 5000 chars long,
Is there functionality in excel to wrap this text around when the text
reaches the vertical page break?
"David Kennedy" <firstname.lastname@example.org> wrote in message
> Is there word wrap functionality in excel?
> If in cell A1 I have a string of text say 5000 chars long,
> Is there functionality in excel to wrap this text around when the text
> reaches the vertical page break?
You...Possible? Using Word template .dot file as app's doc template?
Just curious... I was wondering if a Word .dot file could be used as a
template for my app's document. It would give users the option of
customizing the look of output from my program without my having to
duplicate a lot of functionality. For them it would be a familiar way to
do the formatting. A win/win as they say.
Do Word documents have a published format, or are redistributable .dll
files available from Microsoft (at extra cost) to do this?
...not able to move FLAG STATUS column in Outlook 2003
I tried to move FLAG STATUS column from the very right
side to the left side when I am in my Inbox. IT WON'T LET
Anyone was able to do that?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Kenny Shu asked:
| I tried to move FLAG STATUS column from the very right
| side to the left side when I am in my Inbox. IT WON'T LET
| Anyone was abl...Charts look different when pasted into Word by different users
I work for a national organsiation. When users in different locations paste
exactly the same chart into Word, using exactly the same method, the charts
look different: specifically, the font on the axis labels distorts slightly.
This makes it very difficult for documents incoporating charts to be created
across sites in a uniform manner.
There may be subtle differences in the charts. Check that the Font Autoscale
checkbox has the same state (checked or unchecked) for all charts.
Also, which version(s) of Office is/are in use? The way Excel charts are
pasted into Word has evolved.
- ...Money 2007 tries to update on each start
On each start up, Money 2007 advises that in order to run properly an update
to Money 2007 is necessary. When I click OK it downloads files and again I
click to start the upgrade. After a few minutes the update completes and a
dialog box advises that I should restart Money and if it will not open
properly I should restart my computer. I do so and all seems to be OK, but on
starting money the update dialog box is back. I checked the Money folder and
the update log shows that the update completed. So how do I stop the annoying
update dialog box from displaying on each start?
"GWL&qu...constant for Format Picture dialog box?
Anyone know the constant (named or numeric) for the Format Picture
dialog box? It's not wdDialogFormatPicture -- that just opens the
I've tried using SendKeys to walk through the dialog but it only works
sometimes; it's just not reliable enough, even using a sleep routine.
Or, failing that, anyone have any suggestions for automatically
compressing and downsampling (to the "web" setting of 92 dpi) in image
that has just been inserted. It needs to be something that's entirely
within VBA or makes a shell call to a tool that I can be...Autofilter in Excel 2007
I have a sheet of financial data to which I have applied the autofilter.
Clicking on the downarrow in each of the header fields produces a series
of options one of which is the filter. This filter box then lists the
discrete data for that particular field with an associated checkbox.
However, the one field I do want to filter in this manner - "Payees" -
displays a Text Filter box with only one choice: Select All. In Excel
2003 all the Payees would be appropriately listed for selection.
Que pasa? I want to use this approach to extract records pertaining to
Hi...Safe to Move?
I remember seeing an article about moving $NtServicePackUninstall$ files to
free up space. I think it was for Windows 2000 Server. Is it possible to do
this for Windows 2003 server?
Thank you for your help!
Hello Mr. JYC,
Yes, you can do it and if are sure that there is no need to uninstall it
you can delete it.
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
** Please do NOT email, only reply to Newsgroups
** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.ht...Read Receipts won't move to 'delete bin' after processing
Very simply, my read receipts won't move to 'delete bin' after they are processed. This doesn't seem like a complex process. The tracking option allows me to either turn this rule on or off. What else am I supposed to do? I have receipts all over the place and I end up deleteting them manually.
You have to delete it by yourself. It wont work with a
>Very simply, my read receipts won't move to 'delete bin'
after they are processed. This doesn't seem like a complex
process. The tracking option allows me to either ...mail moved from netscape to outlook?
Hello! I would like to know is it possible to move the
mails from netscape mail to outlook? And what is the way?
>Hello! I would like to know is it possible to move the
>mails from netscape mail to outlook? And what is the way?
<email@example.com> wrote in message
> >-----Original Message-----
> >Hello! I would like to know is it possible to move the
> >mails from netscape mail to outlook? And what is the way?
...Word 2007 Headings
At the top of my screen Ihave Home, Insert, Page Layout etc. I have to click
on these to open the subsets below them. How do I lock the subsets so that
they are visible all of the time? Thanks.
On Tue, 26 Jan 2010 17:44:05 -0800, longmere
>At the top of my screen Ihave Home, Insert, Page Layout etc. I have to click
>on these to open the subsets below them. How do I lock the subsets so that
>they are visible all of the time? Thanks.
There are multiple ways:
- Double-click any of the items.
- Press Ctrl+F1.
- ...Manipulating embeded exccel in word (Repost)
I have seen quite a few posts on this and know it is "easily"
accomplished, however I have a bit of a different requirement.
I have a Word document that I have embedded the following:
- 1 Sheet that holds score data that users can edit within word
- 6 Graphs (from the same workbook) that report the data in different
What I want to happen is that when the data in the embedded worksheet
is edited, then all the other graphs update to reflect the edited data
Any ideas ? I have one, which is to cycle through each embedded chart
and copy the data scores ...Live Mail,I can't move message "unknown Error" appears
There are several messages that I want to place in folders, but when I try
to move them, I receive the message "Unable to move, Unknown Error". This is
more than annoying, as these are important messages from various
organizations I belong to. I like to archive these within the confines of
Live Mail, and I don't want to hve to go in and out to various folders. Any
help will be appreciated.
Windows Live Mail Newsgroup.
In your newsreader:
On the Web:
http://www.microsoft.com/communiti...Copy or Move row on condition to different and/or multiple sheets
I'm new to the world of programming in excel but have programmed elsewhere
What i am trying to do is to have a todo list setup, ive searched long and
hard and can't find anything that quite fits my bill that i can replicate and
alter to work so am asking for some assistance.
I have a workbook with six sheets, All Jobs, Evaluation, Authority, In
Progress, Completed and a helper sheet. In all jobs i have 9 columns A-I
(atm A being spare) that have information that i need to show. In column 'I'
i have a dropdown box using the helper sheet for p...Moving Exchange 2000
I have a exchange 2000 server running on windows 2000 which I need to move
onto a new server/hardware but cannot find techincal documents telling me
how to do this. The only documents I can find are on disaster recovery which
doesnt seem to cover moving exchange across onto new hardware. Does anybody
have some a document ???
Also I would like to run exchange 2000 on server 2003, I'm guessing that
this won't be a problem to move it onto new hardware running server 2003 ??
Use the move-server method detailed here:
Neil H...Why the change in default color palette in Word 2007?
My team has been using the bright blue in Word 2003 default palette for
specific need. We recently upgraded to Word 2007 (about time) and we've found
this specific blue is no longer available in the defaults. In fact, the
palette as a whole seem to be more muted and more "natural," which I really
prefer. I'm trying to make a case for the new blue and wondered whether
Microsoft conducted any surveys/studies (that I can access) to explain the
It is still available. If you click on More colors you can select the colors
you used in 2003. I also pref...Moving Pages between two publications
How can I move several entire pages from one document to another? Not simply
the content of the page, but the format as well as positioning?
Select all the elements on one of the pages and Group them together (a
little icon will appear at the bottom of the bounding box - click it to lock
the group) before you Copy and paste to the other publication.
"FrankDe" <FrankDe@discussions.microsoft.com> wrote in message
| How can I move several entire pages from one document to another? Not
| the content of the ...Move mailbox rights in Exchange 5.5 #2
What is the most restrictive set of rights that would allow an administrator
to move mailboxes between 2 servers in the same site? Providing the
administrator an admin role on the Servers container, on each server, or on
the Private/Public Information Store gives him undesired privileges (like
changing default storage limits).
Thanks in advance for any assistance.
...Excel 2007 Run Remote/Server/Network/Shared Macro From Custom Butt
In Excel 2003 this was straightforward: add the add-in regarless of location
and assign it to a button.
I have tried several things in 2007 without success. I've followed the usual
links (including to Rondebruin and the others!), local add-ins running remote
add-ins, abused my keyboard, kicked some furniture, etc... Still I haven't
found a solution.
I'm sure the solution isn't as easy as in 2003 but if anyone knows it I
would appreciate some advice/directions.
...Move users from none Business Unit to other
hi, is it possible to move a user from one business unit to other ?
Yes it is. However when you move them they will lose their security role so
you will need to add a security role to their user record
"M. Ceccacci" <firstname.lastname@example.org> wrote in message
> hi, is it possible to move a user from one business unit to other ?
should have said!!
to do this go to settings, business units, users then open up the users
record then click actions - change business unit.
once done make sure you reassign...Formatting numbers as words
I found the link to http://www.mvps.org/access/modules/mdl0001.htm suggested
in an earlier question. How do I attach this to a specific field? I have a
dollar amount that I need to print in words and I don't know how to
accomplish that. Thanks for any help.
On Mon, 23 Apr 2007 13:28:02 -0700, kltino wrote:
> I found the link to http://www.mvps.org/access/modules/mdl0001.htm suggested
> in an earlier question. How do I attach this to a specific field? I have a
> dollar amount that I need to print in words and I don't know how to
> accomplish that. Thanks for any help...moving companies moving loans moving budget
moving companies moving loans moving budget http://www.movingcompanies.co.il
...Moving from Outlook on PC to Entourage on Mac
I'm trying to move to a Mac from a laptop that died and use the Office 2008
for Mac. Can't find the Pst file on the laptop hard drive and it doesn't
seem easy to import from outlook. Any suggestions?
Locations are here
Outlook requires the data file to be located on your current system, (Not so
it overwrites any existing data file) before you open it within Outlook (or
"GeorgeK" <GeorgeK@discussions.microsoft.com> wrote in message