macro 2003 vs 2007

[dboat]

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

 

[Don Guillett]

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.

 

[dboat]

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





- 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

 

[Gord Dibben]

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?