Thread: Prevent users from running macros
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
  
Posts: 535
Default Prevent users from running macros
Hi Alan,

Add

Option Private Module

At the top of each module in the project.

Alternatively, make each Sub Private.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Reply With QuoteReply With Quote