![]() The sheets are 'Menu','Data','Titles','Introducer','Reason','PassedTo'īutton 1 opens a userform with 17 textboxes, 4 combo boxes, 2 check boxes, ive got 6 text boxes as required fields and 1 combo box required. The workbook is also protected so people dont add a new worksheet. User opens workbook: enters the password to get in.Īll sheets are hidden and protected apart from the first 'Menu' sheet. Glenn: Yea recently added that password to my workbook, works great just havent got a different sheet to pop up if someone doesnt enable macros.īrad: I am using Excel 2002 in windows xp pro. If InputBox("Please enter your password")=Pswd Then ws.Visible=xlSheetVisibleĮnd Sub RE: workbook password Epsilon101 (Programmer) If ws.Name "Splash screen" Then ws.Visible = xlSheetVisible If ws.Name "Splash screen" Then ws.Visible = xlSheetVeryHidden ![]() Set wsSplash = Worksheets("Splash screen") Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)ĭim ws As Worksheet, wsSplash As Worksheet
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |