View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DNF Karran[_18_] DNF Karran[_18_] is offline
external usenet poster
 
Posts: 1
Default Prevent users from running macros

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