Hi

I have workbook that needs macros to be enabled i have found a thread see link below that displays a splash screen if macros are disabled BUT the code hides all the sheets and shows only the splash screen the problem i have is i have about 30 odd sheets that are hidden all the time and about 10 that are visable, how would are alter the code to suit my needs


http://www.excelforum.com/showthread...ableing+macros

Thanks