I created a 2003 file with macros. Some of our people use 2007..how
can I get the macors from 2003 to work i 2007?
Ron

They should work ok. There are some that have been killed.
If you find one that doesn't, post here with details and we will help.

-- 
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett@gmail.com
"dboat" <dboat17@aol.com> wrote in message 
news:6facb062-4292-4378-894b-ccaedaaf8e97@u26g2000yqu.googlegroups.com...
>I created a 2003 file with macros. Some of our people use 2007..how
> can I get the macors from 2003 to work i 2007?
> Ron 

On Jun 6, 8:54=EF=BF=BDam, "Don Guillett" <dguill...@gmail.com> wrote:
> They should work ok. There are some that have been killed.
> If you find one that doesn't, post here with details and we will help.
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguill...@gmail.com"dboat" <dboa...@aol.com> wrote in message
>
> news:6facb062-4292-4378-894b-ccaedaaf8e97@u26g2000yqu.googlegroups.com...
>
>
>
> >I created a 2003 file with macros. Some of our people use 2007..how
> > can I get the macors from 2003 to work i 2007?
> > Ron- Hide quoted text -
>
> - Show quoted text -

The macro is quite simple. purpose & operation:
1. Highlight row from database tab you wish to print.
2 Click IR buttom and form will print
(it copies highlighted row and pastes special into row 1)

Sub IRForm()
'
' IRForm Macro
' Print an Install and Removal form
' ActiveSheet.Paste
' Keyboard Shortcut: Ctrl+i
'
    Selection.Copy
    Range("A1").Select
    Selection.PasteSpecial Paste:=3DxlPasteValues, Operation:=3DxlNone,
SkipBlanks _
    :=3DFalse, Transpose:=3DFalse
    Sheets("IR Form").Select
    Application.CutCopyMode =3D False
    ActiveWindow.SelectedSheets.PrintOut Copies:=3D1, Collate:=3DTrue
    Sheets("Database").Select
    Selection.ClearContents
    Range("E2:O2").Select
End Sub

 Works in 2003 but NOT in 2007
Anything you can provide is most appreciated.
Ron

Works fine for me in 2007.

Have you saved as a macro-enabled workbook?

Do users allow macros to be enabled under their security settings?





On Mon, 7 Jun 2010 07:43:30 -0700 (PDT), dboat <dboat17@aol.com> wrote:

>On Jun 6, 8:54?am, "Don Guillett" <dguill...@gmail.com> wrote:
>> They should work ok. There are some that have been killed.
>> If you find one that doesn't, post here with details and we will help.
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguill...@gmail.com"dboat" <dboa...@aol.com> wrote in message
>>
>> news:6facb062-4292-4378-894b-ccaedaaf8e97@u26g2000yqu.googlegroups.com...
>>
>>
>>
>> >I created a 2003 file with macros. Some of our people use 2007..how
>> > can I get the macors from 2003 to work i 2007?
>> > Ron- Hide quoted text -
>>
>> - Show quoted text -
>
>The macro is quite simple. purpose & operation:
>1. Highlight row from database tab you wish to print.
>2 Click IR buttom and form will print
>(it copies highlighted row and pastes special into row 1)
>
>Sub IRForm()
>'
>' IRForm Macro
>' Print an Install and Removal form
>' ActiveSheet.Paste
>' Keyboard Shortcut: Ctrl+i
>'
>    Selection.Copy
>    Range("A1").Select
>    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
>SkipBlanks _
>    :=False, Transpose:=False
>    Sheets("IR Form").Select
>    Application.CutCopyMode = False
>    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
>    Sheets("Database").Select
>    Selection.ClearContents
>    Range("E2:O2").Select
>End Sub
>
> Works in 2003 but NOT in 2007
>Anything you can provide is most appreciated.
>Ron