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.
Brad: I am using Excel 2002 in windows xp pro.
The setup i have is:
User opens workbook: enters the password to get in.
All sheets are hidden and protected apart from the first 'Menu' sheet.
The workbook is also protected so people dont add a new worksheet.
I have got 4 buttons in the menu.
-1 'Open input form'
-2 'Maintain combo lists'
-3 'Export data to separate workbook'
-4 'Save workbook'
The sheets are 'Menu','Data','Titles','Introducer','Reason','PassedTo'
Button 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.
Sheets Titles, introducer, reason, passedto hold the data that is used in the combo boxes, they are hidden and protected.
Button 2 goes to a userform to maintain these sheets without being able to go into them, so the user selects the combobox to edit using radio buttons and a listbox shows whats in there, they then add or delete what they want to.
Since these are all protected writing to them required to unprotect and protect again.
Button 3 - This exports the info in 'Data' sheet, which is just transactions from the first userform. This sheet is hidden and protected, i have used the copy property of the sheet in vba to move this to a new workbook, but to do it i had to unprotect and unhide it and then protect and hide again.
Button 4 - This just saves the workbook if they havent already saved, just so its there infront of them, because if they add a transaction or change the cbo box tables and dont save, you get the idea...
Well thats what i have setup.
Brad im just not sure how to set your code up to work correctly thats why i wanted to see it in psuedo, thanks for any further help from anyone.