View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Hutchins Alan Hutchins is offline
external usenet poster
 
Posts: 21
Default Prevent users from running macros

Hi,

I have a workbook, where the VBA code is password
protected.

The macros within the workbook are operated by buttons -
so I'm happy with that.

However, what I really want to be able to do, is to stop
users from selecting Tools, Macro, and then running a
macro from there (NOTE - I do not want to hide this option
from the Toolbar). Is there any way of preventing users
from running a macro in this way ?

Note - Also, I do not want to protect the workbook either.