Working with Pictures and .....

[Hari]

Hi,

I have elementary knowledge of macros in Excel.

In Word it was first attempt. (Word 2002) . I created a macro for cropping
off a picture to my specifications ( I had to process many such pictures)

Doubts:-

a) I did not specify a shortcut for the macro while creating it and now I
want to create one. Tried going in to Tools->Macro->Macro and accessed
"Edit" , "organizer" etc but not able to find a button in which I could
specify a shortcut

b) Also is it possible to indicate or change the shortcut in the VBA code?.

c) After doing Cropping I was resizing my picture by expanding the bottom
right. I noticed that if the macro recorder is on then Im not able to get
the resizing operation done. Is the resizing not possible under macro
recording.

d) Also I noticed that if recorder is on then I cannot activate/select a new
picture. is this normal.

e) Lastly (not a VB doubt) how does one insert a new page/sheet in Word.
When I have a pig picture in my last page and suppose I have to insert/paste
more pictures below that then doing enter doesnt work. I had to resort to a
crude method of lot of text in the first line of my present last picture and
then press lots of enter till a new sheet is created, then cut the present
last picture and paste it on to the front of the newly entered gibberish and
after that whenever I wanted new sheets I went on to paste my picture at the
front of those gibberish typing so that new sheets are crested
automatically. What is the better way to do this .( i looked at insert but
couldnt find anything..)

Regards,
Hari
India

 

[Chad DeMeyer]

Hari,

a) To specify a keyboard shortcut, go to Tools>Customize, click on the
Keyboard button, choose Macros as the category and select the appropriate
macro under Commands, then type the new shortcut key combo in the space
provided and cliss Assign.

b) Keyboard shortcuts can be modified in VBA using the KeyBindings
collection and the KeyBinding objects contained within it. However, this
would be a complex undertaking for a newbie. You'd need to do your homework
first.

c and d) The macro recorder will not record any actions which cannot be
performed using the keyboard only. So you could, with macro recording
turned on, go to Format>Picture, go to the Size tab, and make precise
adjustments, and that will be recorded. But you cannot adjust the size by
clicking and dragging an edge of the picture because that action can't be
duplicated using only the keyboard. Likewise, you can't select pictures or
objects in the drawing layer with the keyboard, so in order to perform
operations on them with VBA you have to get a handle on them in some other
fashion. Once again, this is a complex undertaking. Especially if you had
this in mind as a general purpose macro rather than targeted at a specific
document or template.

e) The easiest way to overcome this is to go to Format>Picture, on the
Layout tab change wrapping to 'Inline with text'. The picture will then be
positioned and selected in the same way as any text in the document is.

Hope this helps
Regards,
Chad

 

[Hari]

Hi Chad,

Thanx a lot for offering fantastic insight on macros "The macro recorder
will not record any actions which cannot be performed using the keyboard
only. "

I wasnt aware of this.

Just a doubt regarding point d) I already have the option "inline with text"
selected (default selection). So, dont know what is causing the problem.

Regards,
Hari
India

 

[Cara]

for e) if you want to keep your pictures floating, you could insert a page
break
"insert > break" at the top of the page and this inserts a new page, however
if this is above the line that the picture is anchored to, your pic will jump
to the new page, so make sure you pic is moved up a bit from where you're
inserting.

 

[Hari]

Hi Cara,

Thats what the problem is. How do i ensure" however if this is above the
line that the picture is anchored to"

Because my picture is occupying the FULL page and this picture is at the end
of the document. Now, I want to add more stuff below this picture. and each
time I press enter then "your pic will jump to the new page" happens.

So how do I bring cursor to the last line of the last page...

Please guide me.

Regards,
Hari
India

 

[Chad DeMeyer]

Hari,

Press enter. Your pic jumps to a new page. Select the picture, Cut.
Depress up arrow key on keyboard, now Paste. If your picture truly occupies
the whole page, you should now have a blank page following the picture.
Otherwise, you have a blank paragraph following the picture on the page it
occupies.

Regards,
Chad

 

[Hari]

Hi Chad,

Problem is as soon as I cut the picture and paste it to the prevoius page
then the newly created blank page (which was created by doing enter) also
disappears.

Its as if Word calculates that since there is no new stuff below so it
automatically removes that page

Thats why I said in my first post that for overcoming this trivial
problem..." I had to resort to a crude method of lot of text in the first
line of my present last picture and then press lots of enter till a new
sheet is created, then cut the present last picture and paste it on to the
front of the newly entered gibberish and after that whenever I wanted new
sheets I went on to paste my picture at the front of those gibberish typing
so that new sheets are crested automatically. What is the better way to do
this" In this method since I enter some dummy text the text moves to the
next page when I cut the picture below it and paste it in front of it. This
way I think word calculates as the last page not being blank.

Regards,
Hari
India