Button on Sheet without macro's

[burlinghamla]

Our IT security has installed a program which removes all macro's when a file is sent through the firewall. Is there any way I can create the form without macros'

We have about 10 buttons doing various tasks. e.g.

~the button print previews the form~

Sub Button4202_Click()

MsgBox ("Quotation Request Form Correct")
ActiveWindow.SelectedSheets.PrintPreview ' preview

End Sub

 

[oldbrewer]

print out the macros as text on a separate sheet and tell the "receiver" to re-install them.

ask IT to design a macro approval system ie you submit an application for IT approval for your macro...