You can hide them using private statements though it depends on you
structure.
If the buttons call subs in a spearate module you will need the modul
set up as:
Option Private Module
Public Sub Prog1
'THis sub is in a module called by a sub from a button and can only b
seen by
VB not users.
End sub
If the buttons call subs in the same module themselves:
Private Sub BUtton_Click
Run Prog2
End sub
Private Sub Prog2
End Su
--
Message posted from
http://www.ExcelForum.com