Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros will not work when sheet e-mailed
I have created macros stored in all open workbooks and they work perfectly
but when I e-mail the workbook it will not work for other users, if they access it or copy it from a common folder it works for them but I need to e-mail it to multiple users. they are getting run time error '1004' Insert method of range class failed and when I debug the line that fails in each macro is Selection.Insert Shift:=xlDown Help please I am not good at VBA code is below Rows("36:36").Select Selection.Insert Shift:=xlDown ActiveWindow.SmallScroll Down:=9 Range("A36:G36").Select Selection.Interior.ColorIndex = xlNone Rows("36:36").RowHeight = 17.25 Range("A36").Select ActiveWindow.SmallScroll Down:=-15 Range("B20").Select Selection.Copy Range("A36").Select ActiveSheet.Paste Range("B36").Select Application.CutCopyMode = False End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros will not work when sheet e-mailed | Excel Programming | |||
Personal.xls macros will not work in any other sheet | Excel Programming | |||
Personal.xls macros will not work in any other sheet | Excel Programming | |||
Personal.xls macros only work in that sheet | Excel Programming | |||
links within excel don't work when workbook is e-mailed - why ? | Excel Discussion (Misc queries) |