Excel in a Tablet Question

[Guest]

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

 

[Guest]

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

 

[Guest]

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]

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