protecting a group of cells not a whole worksheet
I would like to protect a group of cells and not a whole worksheet but I haven't been able to figure out how to do this. I think this would be the best way for what I am wanting to do. I have a spreadsheet that I send to 13 people. They make changes and send back to me and then I have to up-date the changes. If I could protect all the cells except for the one they enter in - then I could save the file on a shared drive and it would eliminate me up-dating. Is there a way to do this?
select the cells for which you want to allow entries. After this goto
'Format - cells - Protection&...Attachment Icons not printing with printed e-mail
I am working with Windows 98, Microslft Outlook 2000.
When I send an e-mail with an attachment i.e. Word or
Excel, in the past I have gone into my Sent folder, called
up the e-mail and printed it, and the icons of the
attachments I sent with that e-mail would print also.
Suddenly it has stopped doing that. I had this problem
before, but it "went away" Does anyone know setting I can
use to fix this if there is one, or what's going on?
I think the format of the message has to be plain text in order for the
attachment icons to print.
MVP -...Access report preview and print only the first page
I'm using 2 buttons for reporting counted values from a tableform.
The counted values are the results of all records and the report now
shows as much pages as there are records.
On each page the same data is reported.
Problem now is that when the user push on printreport then...... he
got a lot of (the same)pages.
Till now I solve it to say.... only print the first page.
Is there an option that the report shows only page 1 of 1, so the user
can only print this one.
Below the macro linked to 2 buttons for the same report.
'Based on the...unable to print E-mail
I am running outlook 2003 and I keep getting an error when
I try to print any e-mail from outlook. If i save the e-
mail to my docs and then print from there everything is
And that error would be...???
Also describe your method of printing as you can do it in many many ways.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Dave G" <firstname.lastname@example.org> wrote in message
>I am ...print in blocks in excel
How can i keep "for exemple"; 5 rows together whin i print so that the
furst 2 are not on page 1 and the last 3 on page 2.
But that the 5 rows are all on page 2 whin the 5 rows do not fit anymore on
my form is bild up in blocks of rows that must stay thogether. The blocks
(groep of rows) can be hidden so that the position of the blocks can change.
can i do this with a macro?
You don't need a macro. In the View menu, select Page Break Preview, and use
the mouse to move the horizontal blue line so you will keep the 5 rows
together. Then switch back to Normal vi...Table of contents with hyperlinks to worksheets, plus "home" hyperlink
I would like to find a way to insert a "Home" hyperlink on all
worksheets in a workbook. The hyperlink should link to Sheet1!A1 (my
table of contents worksheet).
Presently I have to enter the hyperlink one a time on each worksheet.
Is there a way I can do this in one go?
Some background information:
I am trying to automate the process of setting up my workbooks. (I
have nearly worked out how to do this).
Sheet 1 should be the table of contents TOC.
The rest of the sheets: one worksheet per item in the TOC, with a
hyperlink to each worksheet from the TOC.
This macro creates workshe...question about printing
I am a rank newbie, having been given a Publisher 2000 disk and having
installed it. I want to type up my library club's newsletter, and I am
given to understand that Publisher will be more cooperative about this.
I fantasize that I can create two 11 x 17 pages (page 4 and page 1, and
page 2 and page 3), which I could not do in Word because Word figured
out that I don't have a printer which will accommodate 11 x 17 paper.
Will I be spared this annoyance in Publisher or shall I soldier on the
way I have done it for years? Any advice will be gratefully appreciated.
P D S...HTML language shows in printing
I made a background for my emails. It worked fine. I later found that
anytime I tried to print an email that involved my background it came out
with all the markup language like... <DOCTYPE TRML PUBLIC "-//W3C// etc.
Any email completely from someone else printed OK. I then deactivated my
automatic background and found that any email I sent could now be printed
correctly, printing pictures, etc without the markup language.
Is this normal? Is there a way to use the background and still be able to
Do you mean that you created a stationery file?
Could ...Fonts not printing correctly
I recently switched printers. I had a lexmark printer and switched to the
1185 All In One. Ever since then when I print in Publisher using text boxes
the fonts print out as boxes. If I switch it to Word Art I am fine...they
print ok. I contacted Lexmark and they told me to switch my spool settings to
EMF or RAW. Neither one helped. Now they say it is a software problem. Is it?
And how can I correct this?
It certainly isn't a software problem. Could be your driver is giving wrong
information, might uninstall it and reinstall. It is always better to completely
remove a printer driver...Color Issues When Printing
I created a custom color in excel 2003. The color is on 2 different
sheets in my file. I converted this into a .pdf file and the colors
looked perfect on screen but when I printed out the .pdf version, the
color looks different on the 2 pages. It's drastically different, even
though the I am using the same custom color that I created.
Any ideas how to fix this?
I use userforms for entering and displaying data.
How can one print the contents of a userform - also print it if it covers
several pages (I use scroll bars on the form as it is larger than the page)
Can anyone help with suitable advice, links or code?
See "PrintForm" method in VBA help file. It appears that this method will
only print the visible portion of the form. You would have to use
additional code to scroll the form and do additional print to capture the
"Roger on Excel" <RogeronExcel@d...Help Printing stencils
I have read posts about the stencil report wizard in previous versions, but
a web and groups search has failed to find a solution for Visio 2002 (SR1)
I need to print out the stencils (from a category will do) so we can build a
specific stencil based on existing shapes.
Additionally, if anyone can email me the STNDOC.exe that would be great.
a b a k e r A T f l o w l o g i c D O T c o m D O T a u
"Andrew Baker" <abaker@NOSPAM.com.au> wrote in message
> I have read posts about the stencil report wizard in previou...Problem Report on SOP Taxes and Printing Edit List
This is an issue that started since version 7.5 and has been identified as a
Problem Report. However, up until now, there are no service packs, nor
fixes. To recreate, here are the steps:
1. Create transaction in Sales Trx entry window, make sure taxes are
calculated (with tax detail ID from the tax field)
2. Save the transaction in a batch, then print an edit list.
3. The first edit list is okay, print again the same transaction on an edit
list, there will be an error already in the report (ie. Taxes are not fully
distributed, errors in distribution accounts, etc..)
4. Pull up t...How to save each worksheet as a separate file
I'm having a problem with a program that is supposed to read Excel
files, and one of the problems might be the number of worksheets. The
Excel file has 35 worksheets.
Is there any quick way to save each worksheet as its own separate
Steve M - email@example.com (remove dirt for reply)
"I go online sometimes, but... everyone's spelling is really bad.
It's depressing." -- Tara, "Buffy the Vampire Slayer"
Try something like this
Dim a As Integer
Dim wb As Workbook
Application.ScreenUpdating = False...worksheet code
Is it possible to add one more cell in the below work sheet code
Private Sub Worksheet_Change(ByVal Target As Range)
Dim iPos As Long
On Error GoTo ws_exit:
Application.EnableEvents = False
If .Address = "$B$8" Then
If Len(.Value) > 50 Then
iPos = InStrRev(.Value, " ", 51)
If iPos > 0 Then
Offset(1, 0).Value = Right(.Value, Len(.Value) - iPos)
Value = Left(.Value, iPos)
Application.EnableEvents = True
thanks and regards
--------------------------------------...how to create chart using data on different worksheets in xls
I get weekly data of different diseases from different places that I enter
indifferent worksheets in an excel file. I want to see the continuous trend
(disease and place wise). For that, without entering data again, I need to
create a chart using data on different worksheets. How do I do that? Can you
please help? Thanks.
You may have to construct a helper range one another worksheet. With some
clever formulas, it shouldn't require too much work to maintain.
Jon Peltier, Microsoft Excel MVP
Peltier Te...How do I insert an 11x17 page when other pages are 8.5x11?
In a 4-page, double-sided print newsletter laid out in 8.5" x 11" portrait,
how do I make pages 2 & 3 into one 11" x 17" landscape page? I created a
single 11" x 17" page in another Pub file - can I insert it like one inserts
slides from one Powerpoint presentation into another?
No, one size to a document.
I'm trying to figured out how you are going to lay it out. Nothing makes
sense. You say it's double-sided, but what's on the back of Page 1? Are you
trying to make Page 2 11x17 on one side and Page 3 11X17 printed on the
JoAn...publisher 2003 printing problem
I have just installed pub 2003 on my computer and now the
borders become black boxes that take over the item it was
bordering. When the border is removed the publication
prints just fine. Any one had this problem and know the
> I have just installed pub 2003 on my computer and now the
> borders become black boxes that take over the item it was
> bordering. When the border is removed the publication
> prints just fine. Any one had this problem and know the
There are *NO* printing issues that can be directly attributed to Publisher...Deleting Worksheet #2
shimeel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1583
View this thread: http://www.excelforum.com/showthread.php?threadid=27335
...Abort Printing Receipt?
I can't for the life of me find where to turn off the abort print receipt? If
anyone knows this I would realy apreciate it.
Do the following steps:
1. Login to Store Manager Program
2. Click on Database -> Registers > Then Click on Receipt Formats
3. Select the Format you have attached to your register i.e. 40 column
receipts then click on Properties button
4. In the Cancelled click on X button to turn off printing of abort
Please rate it.
Certified Microsoft Retail Management Specialist
Certified Microsoft Great Plains Implementation Speciali...Printing or Emailing a Quotation to a Customer
I have created Customers, Accounts, Price Lists, Product Catalog in CRM 3.0.
I create and activate a Quotation.
Now, how do I get this quotation to the customer?
Does Microsoft CRM allow me to define standard quotation templates, and send
them off to the customer?
I have gone through the online documentation, and my CRM books, and I can't
find any reference discussing how a customer gets the quote generated in
Surely there must be some way of automating the quotation layout & sending.
You could create an email template using the quote, but thi...Copy worksheet ---> worksheet
I have 3 Worksheets in 1 Workbook....
the worksheets are known as...:
each worksheet has at least 2 columns that will have the sam
information as the others..for example:
Manifest has 1 column (A) named Receipt Number, Deliveries and Stuffin
also have 1 column that has this column as well.
My question is, what formula do I need to apply so that when
introduce the Receipt Number in Manifest's Receipt Number column i
will automatically be introduced in Deliveries and Stuffing's Receip
Number Column? That way I dont have to be intro...Refresh data in Protected worksheet
Does the work sheet protection work properly when
refreshing data from access.
I have the range I want to refresh Unlocked and unhidden
and the rest of the worksheet protected, but when i
refresh it tells me the worksheet is protected and I cant
refresh. Is there something I'm missing or is this a
shortcoming of worksheet protection?
just hazarding two guesses.
are you talking about a macro that does it? if so...
are you providing a password to unprotect before you refresh the data?
'your refresh code would go after the above sta...Printing Problem in SQL Reporting Service
Seen a couple of posts about this but no conclusion.
Trying to print a SQL Report from CRM and getting an error 0x80004005. These
reports can be seen on screen and exported but cannot be directly printed to
any printer. Checked all IE settings and put them as low as possible. The
only other thing that might be contributing is Sophos AV.
Any answers anyone ?
...copying a worksheet tab with a chart, without losing chart formatt
If I copy an Excel 2007 worksheet tab with a chart, the copied sheet loses
some of the formatting and / or chart series information. How can I resolve