Changing Shape Text

[ercedwards]

I have the following line of code that changes the text in a shape.

Sheets("Main Menu").Shapes("AutoSaveMaster").TextFrame.Characters.Text = "Whatever"
​

It works just fine with 64Bit VBA 7 but when I try and run it in 32Bit VBA 6 I get the error

Unable to set the text of character class.

Any suggestions around this?

Thanks much

 

[Kenneth Hobson]

Works fine for me.

Either: ActiveWorkbook<>ThisWorkbook, sheet "Main Menu" does not exit, shape named AutoSaveMaster does not exist for that workbook and sheet.

 

[ercedwards]

Solved the issue by changing the Shape.

Thanks