Thread: Macros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sandy Sandy is offline
external usenet poster
 
Posts: 156
Default Macros

If you are refering to the enable or disable macros message box when a
workbook opens than no, as far as my knowledge of vba goes. When you
open a workbook and the user disables macros then any macros in that
workbook will not execute, so any code to hide a sheet or close a
workbook will not run.

Sandy


wrote:
Forgive me if my questions is too basic but I am not a developer. I
would like to know if there is nayway that I can have an excel sheet
close out if macros are not enabled? If not, is there a way to make
sheets not visible if Macros are not enabled? Thanks for any help