Excel in a Tablet Question

We were not able to see any any except for the standard stuff for a blank
macro from the recorder.

This is what we did:
1) Under Test - Macro - we turn the macro record on
2) He then use the pen for the tablet (win xp for tablet) to draw lines,
copy and paste a circle (already on the form).
3) He then turn off the recorder and view the created macro.

We didn't see anything like what you are saying. I do see that when I use
my mouse with a desk top system.

Any help here??

Gary

"CLR" wrote:

> You can record the selection of the completed object (Oval 5 here), and the
> setting of it's properties, as:
>
> Sub CheckShape()
>
> ActiveSheet.Shapes("Oval 5").Select
> Selection.ShapeRange.Fill.Visible = msoTrue
> Selection.ShapeRange.Fill.Solid
> Selection.ShapeRange.Fill.ForeColor.SchemeColor = 13
> Selection.ShapeRange.Fill.Transparency = 0#
> Selection.ShapeRange.Line.Weight = 0.75
> Selection.ShapeRange.Line.DashStyle = msoLineSolid
> Selection.ShapeRange.Line.Style = msoLineSingle
> Selection.ShapeRange.Line.Transparency = 0#
> Selection.ShapeRange.Line.Visible = msoTrue
> Selection.ShapeRange.Line.ForeColor.SchemeColor = 10
> Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255)
>
> End Sub
>
> hth
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Gary" wrote:
>
> > A friend has a tablet with excel on it. He is able to draw object in excel.
> >
> > I wanted to used the macro recorder to record the steps he used, and it
> > doesn't record any hand drawn operations such as drawing circles, lines, arcs.
> >
> > Does any one know I we can record those operations???
> >
> > That would help me in writing VBA code to check the objects color and
> > determine if it needs to be visible or invisible.
> >
> > Thanks,
> >
> > Gary

Sorry Gary, I don't have a tablet, so can't really see what you are
experienceing. I do know however, that there are many other things that the
Macro Recorder will not record, even under normal conditions. I did not
mean to suggest in my post that you should be able to do it. I only
suggested a method of committing the Object name and properties to a macro
after the object had been drawn. I apologize if I mis-led you.

Vaya con Dios,
Chuck, CABGx3





"Gary" <Gary@discussions.microsoft.com> wrote in message
news:C07BC5F4-82FF-4CF0-AECF-AD0282D8D2F5@microsoft.com...
> We were not able to see any any except for the standard stuff for a blank
> macro from the recorder.
>
> This is what we did:
> 1) Under Test - Macro - we turn the macro record on
> 2) He then use the pen for the tablet (win xp for tablet) to draw lines,
> copy and paste a circle (already on the form).
> 3) He then turn off the recorder and view the created macro.
>
> We didn't see anything like what you are saying. I do see that when I
use
> my mouse with a desk top system.
>
> Any help here??
>
> Gary
>
> "CLR" wrote:
>
> > You can record the selection of the completed object (Oval 5 here), and
the
> > setting of it's properties, as:
> >
> > Sub CheckShape()
> >
> > ActiveSheet.Shapes("Oval 5").Select
> > Selection.ShapeRange.Fill.Visible = msoTrue
> > Selection.ShapeRange.Fill.Solid
> > Selection.ShapeRange.Fill.ForeColor.SchemeColor = 13
> > Selection.ShapeRange.Fill.Transparency = 0#
> > Selection.ShapeRange.Line.Weight = 0.75
> > Selection.ShapeRange.Line.DashStyle = msoLineSolid
> > Selection.ShapeRange.Line.Style = msoLineSingle
> > Selection.ShapeRange.Line.Transparency = 0#
> > Selection.ShapeRange.Line.Visible = msoTrue
> > Selection.ShapeRange.Line.ForeColor.SchemeColor = 10
> > Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255)
> >
> > End Sub
> >
> > hth
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "Gary" wrote:
> >
> > > A friend has a tablet with excel on it. He is able to draw object in
excel.
> > >
> > > I wanted to used the macro recorder to record the steps he used, and
it
> > > doesn't record any hand drawn operations such as drawing circles,
lines, arcs.
> > >
> > > Does any one know I we can record those operations???
> > >
> > > That would help me in writing VBA code to check the objects color and
> > > determine if it needs to be visible or invisible.
> > >
> > > Thanks,
> > >
> > > Gary