Macros will not work when sheet e-mailed

  • Thread starter Thread starter Ber
  • Start date Start date
B

Ber

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
 
no Joel this does not solve it my macros work except when e-mailed to another
user and I cannot understand why HELP
 
There is nothing in this part of the code that would give a 1004 error. You
need to find out what line gets highlighted when the rror occurs. This code
is not creting the error.
 
What version of Excel is on the systems that work and don't work? There
are Excel 2007 things that may need to be addressed.
 
Thanks all got it working I needed to put a line in to unprotect and re
protect and now its working on all versions. Many thanks.
 
Back
Top