2007-09-16 23:55:57 · 5 answers · asked by Tigger 1 in Computers & Internet ➔ Software
Use the tools menu to turn macro security off
2007-09-16 23:58:45 · answer #1 · answered by spick&span 4 · 0⤊ 0⤋
What happens when you run the macro? Does it start to run or nothing at all? Usually the visual basic behind the macro comes up with the error highlighted so you can rectify the error you possibly made. It could be simply that your macro security is set too high. I'm wondering though why you bothered creating a macro when it's so easy to simply insert a picture. A macro is really useful only when you're doing repetitive tasks often.
2007-09-17 00:20:42 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Since you probably recently started using Excel, I imagine that the security level for your macros is set too high to allow the macro to run. Just reset the security level. If the macro or person that created the macro has a certificate or is listed as being an OK source, then even at a high security level it should allow the macro to run.
2007-09-18 01:46:00 · answer #3 · answered by devilishblueyes 7 · 0⤊ 0⤋
open tool menu picture toolbar
get the rectangle box inserted & clik insert /add test
copy the picture from the window & paste it in that rectangle.
& your work is done.
2007-09-17 00:02:28 · answer #4 · answered by Anonymous · 0⤊ 0⤋
Sub AddTextBox() application.ScreenUpdating = fake ActiveSheet.Shapes("TextBox1").seen = authentic ActiveSheet.Shapes("TextBox1").replica ActiveSheet.Paste With selection .top = 25 .Width = 200 .Left = 20 .acceptable = 20 end With ActiveSheet.Shapes("TextBox1").seen = fake selection.TopLeftCell.decide on application.ScreenUpdating = authentic end Sub
2016-11-14 16:20:26 · answer #5 · answered by ? 4 · 0⤊ 0⤋