macro 2003 vs 2007

  • Thread starter Thread starter dboat
  • Start date Start date
D

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
 
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.
 
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 -
Click to expand...

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
 
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?
 
Back
Top