View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default Macro assistance

Hi,

Just to be cute and instructive:

If you make the macro a Private Sub. Let's suppose called Test, then you
special users can run the macro with Alt+F8 and type the name of the macro
into the box and press enter. Other users can't see the macro so they are
unlikely to try to type its name.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Rover" wrote:

I created a macro and it works. How can I make sure only a few people can
run the macro? I have a file that goes out to 30 people for budgets inputs.
I only want my group to be able to run that particular macro, not people
outside my group.