Hello all,

To acheive this Ive employed the "hidden (useful) worksheet becomes
visible if macros are enabled" method.

A second sheet is visible, that tells users that they must enable
macros on loading the file. Should they already have macros enabled,
the first thing that is run is to hide this sheet.

Unfortunately, when loading the excel file, it shows the other sheet
for a split second. Is there any way to stop this happening?

Code he

Private Sub Workbook_Open()

Application.ScreenUpdating = False

Call enablemacros

Call openformat

Application.ScreenUpdating = True

etc.........


Then in a module:

Sub enablemacros()

Worksheets("UsefulWorksheet").Visible = True
Worksheets("RemindToEnableMacros").Visible = False

End Sub



Many thanks,
Ed


---
Message posted from http://www.ExcelForum.com/