View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default how might I tell a user they did not enable macros for excel?

Add a worksheet formatted with a message asking the user to enable macros.
Use the workbook_open procedure to hide the sheet and show the form.

---
Tim Williams
Palo Alto, CA


"mike f" <mike wrote in message ...
I have a form full of vbscript. I want the users to see a worksheet with a
warning that they did not enable macros. If they did enable macros I want
the form to show instead of the message.