Hidden rows still visuale under CSV
I'm using Office 97, I've 2 macros : a) hide the rows with amount valu
zero and b) automatic save the sheet to local drive with
csv-extension. But, when the sheet is saved I noticed that in the ne
file the hidden rows are still visual. How to avoid these lines ????
Used code (a) Hidden rows :
Dim RowNdx As Long
Dim LastRow As Long
LastRow = ActiveSheet.Cells(Rows.Count, "W").End(xlUp).Row
For RowNdx = LastRow To 1 Step -1
If Cells(RowNdx, "W").Value = 0 Then
Rows(RowNdx).Hidden = True
Used code (b) save to c...display all hidden rows
I inherited a Workbook. On one of the sheets , there are gaps between row
numbers ( ... 37,38,62,63 ... ).
Placing the cursor on skinny gray area between the row headers (so that the
cross-hair contains two horizontal lines) and then selecting "Unhide" only
unhides a single row.
How to unhide all hidden rows at once ?
Select the entire sheet by clicking the grey box above the row header
and to the left of the column header. Right-click a row header and
In article <#CpwzIYXEHA.3972@TK2MSFTNGP12.phx.gbl>,
"John A Grandy" <j...scanning pictures into an excel spreadsheet
Is it possible to scan a table of numbers into an excel
spreadsheet and be able to add and subtract them?
...red x -pictures don't print
Here's my problem:
I scanned a whole bunch of pictures ito publisher 2007 as part of a booklet
I want to convert into a PDF file and then print (or e-mail).
When I convert the document to PDF, the pictures don't show on the pdf -
only an empty black box or the box with a red x in it. They also don't show
in the print preview page.
I think that the problem may be that I scanned the pics at a very high
resolution - 1200, and somehow this is causing a problem.
1. How can I change the resolution of a picture once I have scanned it in a
2. Or make the pictures ...Pictures do not appear
I am trying to create a brochure in Publisher. When I add a picture
they do not appear. They show up as an object in the graphic manager.
I do have it on in view-pictures. Any ideas? Please help. TIA
Read the third FAQ here
Q: Why can I not see images/shapes/lines when editing my publication?
Mary Sauer MSFT MVP
<email@example.com> wrote in message
>I am trying to create a brochure in Publis...I'd like to know how to protect hidden rows or columns in a worksh
so the users cannot unhide them but at the same time allowing them to edit
the rest of the worksheet.
Protect the cells you dont want touching and hide them then allow the others
to be unprotected.
See Format Cells protection to identify cells for locking and then Tools
Protection to do the job.
"marq" <firstname.lastname@example.org> wrote in message
> so the users cannot unhide them but at the same time allowing them to edit
> the rest of the worksheet.
> ...Download pictures form NewsGroups
Can OutLook Express be setup to just download pictures from different
newsgroups, just like the older newsgroup readers did in the past?
This is an Outlook newsgroup and they aren't the same software. Try here:
Outlook express newsgroups:
microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x
microsoft.public.windows.inetexplorer.ie55.outlookexpress for OE 5.5x
microsoft.public.windows.inetexplorer.ie6_outlookexpress for OE 6.x
Judy Gleeson [MVP Outlook]
Acorn Training and Consulting
Everyone - turn on your Advanced Toolbars and learn how...Saving a picture from excel directly to a file
I would like to know how to save a picture embedded in
Excel directly to a file. I do not want to copy and paste
in a picture editor and then save it.
...Inset picture from file
If I want to insert a picture from a file in Excel, Excel by default opens the My Picture folder. Can I change this default setting to a different folder (like you can do in Word)?
Dunno. But after you've inserted one picture, Excel will remember that
location for further inserts. Or you may wish to put a shortcut(s) to the
folder(s) where you often go. It's only one extra step, and only the first
mvpearl omitthisword at verizon period net
"Larus Astvaldsson" <email@example.com...Publisher-web site creation-pictures
I have created a web page in publisher that consists of text and pictures of various sizes (pixels). It displays perfectly when I test the site before publishing it to the web. The page contains no special features. No buttons, no links, no address book, no counters, etc. etc.. When I publish the page to "MSN Groups" the pictures will not display. Each picture area is blank and only displays an "x" in the upper left hand corner. How can I make the pictures come up on the web page when I publish to the site?
I've never created a page using Publisher (I use FrontPage), n...Can I print the address book with the picture
I am trying to put together an address book in printed format and I want to
include the picture that I have stored for each contact.
Is this possible?
No, Outlook doesn't support printing the pictures.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
New Poll: What type of email a...make dvd/cd from pictures in email folder
how do i go about moving pictures to a folder and copy of pictures to a dvd
or cd? appreciate any help given.
...Can't insert a picture
When i try to insert a picture, Outlook 2007 faults with apologies. This
occurs while the browse window is partly filled out. this has been the case
since I upgraded from a previous version. I have tried all the suggestions
which were in the "Sepron" post, 11/22/07.
What exactly is logged to the Event Viewer about this?
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
http://www.msoutlook.inf...Picture tags in WMP11
Hi there,I've added my pictures collection in WMP11 (11.0.5721.5268) and can
see them in the all picture tree, but I cannot edit the tags like "keywords"
(as I can for music). Any reason for this? I need that for chosing pictures
to be displayed on my "Kodak EasyShare" digital picture frame.Thanks for
On Tue, 23 Feb 2010 11:20:05 +0100, "Jobst"
>Hi there,I've added my pictures collection in WMP11 (11.0.5721.5268) and can
>see them in the all picture tree, but I cannot ed...POS2 item pictures
I've seen some posts allowing RMS to have picture files external to the
database. Is this possible with POS2? I have only seen the manual way through
the File Center. Having to manually add/update each image would be a pain.
Are you intersted for custom solutions?. If so please drop a email to me.
ERP Solutions Specialist
> I've seen some posts allowing RMS to have picture files external to the
> database. Is this possible with POS2? I have only seen the manual way th...Pre-set Picture Frame Size?
I am attempting to design my own pages for my stamp collection and new to
Publisher. Is there a way to insert pre-set size picture frames (slightly
larger than the actual stamp)?
A one row, one column table is the better way. Or create a rectangle the size
you want (right-click, format autoshape, size tab), fill, fill effects, picture
Mary Sauer MSFT MVP
"Pops Jackson" <PopsJackson@discussions....use pull down menu to select a picture #2
I use the Combo Box pull down menu buttons a lot.
I click on the Box, select an item from the list and the relevant data pops
up as expected. How can I make a picture pop up when I select an item from
the Combo Box List?
I think you would need VBA.The picture would not be in the cell, as shapes
exist in a separate layer to the worksheet cells, but you could position it.
What you could do is name the logo by the value in the drop-down, and then
move that to the required position, move all others away.
The problem is that when you select something, you need a way to align t...pictures fail to display
Inserted pictures / graphics are NOT visable. The area format objects are
visable to resize and rotate but the picture or graphic is not visable.
Read the third FAQ here:
Mary Sauer MSFT MVP
"Dave" <Dave@discussions.microsoft.com> wrote in message
> Inserted pictures / graphics are NOT visable. The area format objects are
> visable to resize and rotate but the picture or graphic ...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...Master Picture backgrounds shifting
v. Publisher 2003 sp.3
I have made a file with several masters (8.5"x11") and each with a different
picture background designed for full bleed. I have tried TIF, JPG, TGA, and
PNG (8.5x11, 300 dpi).
The problem: This file is meant to be used by several people to create
newsletters for output on our commercial printer. The files that we
typically use for output are PDF. With margins set to 0, and Acrobat 8
Professional I try to generate a PDF and the image in the background
shifts!!! actually it really doesn't matter what printer I have set to, the
back...Picture help (for an excel virgin) #2
was afraid of that
joga11's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1453
View this thread: http://www.excelforum.com/showthread.php?threadid=26160
...How do I insert a picture and then type over it
I am creating a program for a dinner function. I would like to know 2 things...
1. How do I expand the size of the columns
2. After I insert a picture, how do I type over it instead of around it
> I am creating a program for a dinner function. I would like to know 2
> 1. How do I expand the size of the columns
> 2. After I insert a picture, how do I type over it instead of around
1) It the column is a text box...place your pointer
on the edge of the column and when you see the
double arrow...left click /drag it to ..."Save as Picture" default
When I right-click on a picture and select "Save as Picture" the file type
always defaults to "Graphics Interchange Format" - gif, which is first on the
Is there anywhere I can change that default to jpeg?
...getting the pictures from the example databases
I just started to use the new access 2007 and downloaded the example
databases from microsoft.
they all have pictures in pictureboxes and in the controls so that the
design looks great.
But how the hell do I get these icons, bmp's, png's so I can use them.
...Password Protect Hidden Columns
If I have columns that are hidden and there is a macro
that is there that can unhide and hide the columns, how
can I password protect the unhiding of the columns so they
will only open with the correct password? Thanks for the
I was working with a similar problem the other day. I have a sheet
hidden, that I only want unhidden with a password. I can tell you what
I did, but I don't quite know the code to hide a column, so I can't
translate the code for you.
Made a UserForm, with 2 textbox and 2 buttons. OK, and Cancel.
The password and form name gets put in the text boxes,...