I have found that I have had worksheet charts which are taking data from other workbooks hidden in random places on my sheet before, hard to find esp as the GOTO function didn't seem to work.
You could do a for each loop and output a list, I've just given you a msg box
If Not IsEmpty(DrawingObject) Then
If Selection.Name = "WeekDate" Then
MsgBox "Sheet " & ActiveSheet.Name & "Contains WeekDay"
a = 2
Unfortunatly the contents of the spreadsheet are very confidential inputs into a model, I guess I'm just going to have to live with it... Thanks for your kind offer though.
I'm not going to give you staep by step but can give a start point.
You need a sheet to dump your unwanted users to if they fail the login or when they open the sheet.
Then in the project explorer in VBA editor (alt+F11, ctrl+r) select the sheet, and set the two boxes over the main code to "worksheet" and "activate". Then enter code which will ask a question in an input box and cross reference this aginst you passwords and either let them in or don't.
The vlookup works from the first column, so if you switch you r codes and full names around it should work.
Attached is the revised file.
Let me know if this is what your looking for.
Checkboxes are either true or false, you can assign any numberic or text to the answers or retrive trrue or false conditions from you r data.
Private Sub UserForm_Activate()
If [c2] = "a" Then CheckBox1 = True Else CheckBox1 = False
Seems to work fine for me, I've added another module (option b) which does what I think you want on one line.
Keep me posted!
' cplus Macro
' Macro recorded 06/04/2003 by NAMELESS
ActiveCell.FormulaR1C1 = "=RC[-1]-RC"
Sheets("Department Budget").Range("j8").Value = Sheets("Claim Form").Range("L29").Value + Sheets("Department Budget").Range("j8").Value
Sorry.. forgot that bit just where you had paste before, everything else remains the same.
Hope this helps
rather than paste why not try
which will continue to increase the claim rather than mearly overwriting the current value?
Please anyone, I have an excel file which crashed out while saving, I had just spent 3 days, 20 hours a day creating the code in this file. I cannot open the file and cannot find a way in to the file. Does anyone have any tips for extracting VBA from dead files?