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...copy cells from one worksheet to another
How do I make the "value" or content of a cell on 'worksheet 1' mirror or
copy the font color (and strike through) of a cell on a seperate worksheet?
- 'worksheet 2'?
Copy and paste special|values
If you were using a formula, then that formula can only return the value--it
can't change the format.
Depending on how that other cell changed, you could have an event macro do the
work for you.
> How do I make the "value" or content of a cell on 'worksheet 1' mirror or
> copy ...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 <email@example.com>,
Andrew D <firstname.lastname@example.org> 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...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...Linking dats on a worksheet to control panel
I am in the process of creating a gantt chart in Excel 2007 for various
projects my company performing. I have created formulas so that the current
date used to calculate the number of days remaining and the number of days
past. I was wondering if there was anyway to link the current date to the
control panel so it automatically updates everyday? This way I do not have to
manually do it.
Thanks to everyone that helps
...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...Hyperlink a Visio shape to a worksheet
I have a Visio diagram that represents the computers in ou
computer/server room. I want to create hyperlinks from each of th
shapes that represents a server (for example) to a correspondin
worksheet in a workbook.
I can get the hyperlink to open the workbook, but I can't figure ou
how to drill down to the specific worksheet for a particular server.
Thanks in advance,
Message posted from http://www.ExcelForum.com
not tested but try adding the sheet name with
> I have a Visio diagram that represents the ...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...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?
...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...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 ...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...Go to section of all worksheets
I have set the following macro to unhide column Y in all sheets.
Dim sh As Worksheet
For Each sh In Sheets(Array("sheet1", "sheet2", "sheet3"))
sh.Columns("X:Z").EntireColumn.Hidden = False
However, how do I also get it to select sell H7 and also scroll to the
top left of the workbook in all sheets?
Dim sh As Worksheet
Application.ScreenUpdating = False
For Each sh In Sheets(Array("sheet1", "sheet2", "sheet3"))
With ...Creating a new worksheet from a template
I would like to press a button on one worksheet and create a ne
worksheet that conforms to a template.
1) this is for a series of people who do not work centrally and who ar
not technical i.e. the solution needs to be self-contained within m
workbook and not involve the creation of xlst templates that have t
sit in a certain place on the hard drive.
2) These worksheets will have a series of fields that relate t
'activities'. The user can chose to spawn worksheets for one or mor
activities. I would like a summary sheet to add all the activit
information from as many activit...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.
...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 ...Comparing two values in different worksheets and extracting value
I have the following problem with which I need some help:
I have two different worksheets with article numbers and quantity data. One
of these includes the whole set of articles, while the other holds only a
selection of articles. I need to compare the article numbers and extract a
value from another column in the first worksheet when these article numbers
article number quantity
I want to extract the quantity number from worksheet 1 into worksheet 2,
only for the matchin...Protecting worksheet
I have protected a worksheet but when I scroll up too far up to the top or
too far left instead of stopping there it takes me of to a different part of
the spreadsheet. Does anyone know how to stop this?
Look at freezing the pane to keep certain rows and/or columns from scrolling
off of the screen.
Excel 2003 and earlier: Window --> Freeze Panes
Excel 2007: [View] tab, "Window Group", Freeze Panes pulldown.
> I have protected a worksheet but when I scroll up too far up to the top or
> too far ...Creating Purchase order worksheets in HQ through rules
I would like put some code in a web service in order to create a purchase
order work sheet.
Could I access to work sheets logic using qsrules to construct a worksheet?
I looking for a method like QSRULES.CreatePOWorkSheet
...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...moving companies moving loans moving budget
moving companies moving loans moving budget http://www.movingcompanies.co.il
...View Old Worksheets
We have a customer that would like to look at an old worksheet in HQ.
But the worksheet status viewer only shows the last 140 items. is there
anyway to access historical worksheets?
Version is 1.3.
Thanks and regards,
huh ??? how does it possible? only 140 items???
r u viewing it thru ??? View-->worksheet Status if yes...check with the
flags maybe you only have selected blue flag (Approved for processing) ; most
of the old worksheet are in Green (Completed successfully) or Red (with
Warnings) or others..
but if you chose to view it thru Admin-->Worksheets and it shows only...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
news:64D74ACC-C994-441B-8EA1-FDC4D30B3F88@microsoft.co...Moving Folder error
Using OL 2007, I am moving some folders and I get a error message 'Folder is
Any ideas ? I can copy the folder elsewhere but not more it.
"Ronnie" <rarneja@REMOVEMEnc.rr.com> wrote in message
> Using OL 2007, I am moving some folders and I get a error message 'Folder is
> Any ideas ? I can copy the folder elsewhere but not more it.
Are you using an Exchange account or some other type of account? If another
type, what? Have you emptied your Deleted Item...default save directory for a templated worksheet
Is there any easy way to automatically have a template save to a particular
location for that template only?
e.g the 'Quotes' template saves to the quote directory
the Orders template saves to the orders directory
Please clarify: do you want to save the TEMPLATEs to those directories, or
do you want to save the files CREATED FROM THE TEMPLATES to those directories?
If the latter, you could do it with code imbedded within the template.
"Mike Lang" wrote:
> Is there any easy way to automatically have a template save to a particular
> location for th...