A
Alan Hutchins
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.
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.