Users need to enable macros to view the workbook
Posted on 2005-04-10
I need to have users enable macros to view my workbook. If a user does not enable macros my workbook needs to either close or hide all the sheets but the warning sheets that tells them MACROS NEED TO BE ENABLED.
I've read other comments people on expertexchange have posted on this topic, but for some reason I cannot seem to be able to properly implement it into my workbook. I need to use either autostart macro to do this or Workbook_Open, and I need the following code to somehow be implemented within:
Application.ShowWindowsInTaskbar = True
Application.WindowState = xlMinimized
Application.Assistant.Visible = False
This is what needs to execute if macros are enabled. If macros are disabled then we need something that will hide all the other sheets, but the warning sheet.