View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas
 
Posts: n/a
Default How can force enable macros to be able to open my workbook?

set up the workbook so that the only sheet showing is one with a message
which says "You must enable macros for this workbook to work." in a large
obvious font. Have the workbook password protected and all sheets
veryhidden.
In the workbook_Open event, hid that message-sheet & display the sheets
which you'd need to have visible.
So, if the user disables macros all they see is a sheet with a message on
it; If the open it with macros enabled, the Open event will kick in and make
the workbook work the way you want.
Bob Umlas
Excel MVP

"kcdonaldson" wrote in message
...
I would like to be able to force employees to enable macros for a certain
workbook or it will not let them open the workbook. And maybe put a

password
on it so if i would like to modify the workbook without the macros

enabled.