Hi Joshua, Your efforts are great. I have downloaded the files too. but I am not able to enter the password even after enabling the Macros. Am I missing anything? Can you please help? Thanks Tanya
From India, Ahmadabad
From India, Ahmadabad
Hello All,
I have been following this & other threads of Joshua for a while and was upset to see how certain individuals act weired in an open forum. If you created something and have posted on an open forum like citehr, then you should not password protect it, this is an open forum helping each other all the way is the essence of it. Moderators you should take this up seriously.
Joshua, pardon me but I cracked your Excel application and has made password free for all to customize it as per their needs. There were so many people requesting you to share the password but you never did. Hence I had to hack it ethically for the benefit of all in general.
Enjoy Friends! Sorry Joshua!
From United States, Clifton
6I have been following this & other threads of Joshua for a while and was upset to see how certain individuals act weired in an open forum. If you created something and have posted on an open forum like citehr, then you should not password protect it, this is an open forum helping each other all the way is the essence of it. Moderators you should take this up seriously.
Joshua, pardon me but I cracked your Excel application and has made password free for all to customize it as per their needs. There were so many people requesting you to share the password but you never did. Hence I had to hack it ethically for the benefit of all in general.
Enjoy Friends! Sorry Joshua!
From United States, Clifton
Hi this is satish i have downloaded your Systemativ and Faster Attendance Fully Registered with Macro Edited, Its a very beautiful planned and worked software for Salary Payroll and a great help for all HR people but i am now able to unlock the Pay Slip Cum Time Card sheet could you please help me the password, how to edit that sheet.
My E Mail id is
.
Thanking you
Satish DHarwadkar
EDITED ON 28.01.2010 (and link file also given open the zip folder and copy the files and paste in ur addin
Regards,
Joshua
How to Use: Step by Step
1. Open Workbook
2. Enable Macro
3. Enter Login Password: @joshua
4. Unhide All the Workbooks
5. Unprotect Worksheet Password: alvina
6. While Exit Lock all the workbook click on lock or Lock user Password: joshua@
U have find all the there. Attendance register, Payroll calculation, Payslip, Advance Register, Consolidated Statement, Form 3A, Form 6A, Form 5, 7, ESI yearly Returns, Form 12A, Ect.,
This will help you guys.
1st Sheet PASSWORD: Carrot
All other sheet password: Alvina
Login Password: @joshua
Lock Password: joshua@[/QUOTE]
From India, Pune
My E Mail id is
Thanking you
Satish DHarwadkar
EDITED ON 28.01.2010 (and link file also given open the zip folder and copy the files and paste in ur addin
Regards,
Joshua
How to Use: Step by Step
1. Open Workbook
2. Enable Macro
3. Enter Login Password: @joshua
4. Unhide All the Workbooks
5. Unprotect Worksheet Password: alvina
6. While Exit Lock all the workbook click on lock or Lock user Password: joshua@
U have find all the there. Attendance register, Payroll calculation, Payslip, Advance Register, Consolidated Statement, Form 3A, Form 6A, Form 5, 7, ESI yearly Returns, Form 12A, Ect.,
This will help you guys.
1st Sheet PASSWORD: Carrot
All other sheet password: Alvina
Login Password: @joshua
Lock Password: joshua@[/QUOTE]
From India, Pune
Hi this is satish i have downloaded your Systemativ and Faster Attendance Fully Registered with Macro Edited, Its a very beautiful planned and worked software for Salary Payroll and a great help for all HR people but i am now able to unlock the Pay Slip Cum Time Card sheet could you please help me the password, how to edit that sheet.
My E Mail id is
.
Thanking you
Satish DHarwadkar
From India, Pune
My E Mail id is
Thanking you
Satish DHarwadkar
From India, Pune
dera Joshua, Please provide the user admin Password.so that i can edit the months in INdex sheet
From India, Hyderabad
From India, Hyderabad
Dear Joshua,
Please provide me the details of Password as i Cannot update the month calender in the index sheet. It is still showing november 2009 & it is interlinked with all other sheets i Believe.Please update it and forward me on my
.
From India, Hyderabad
Please provide me the details of Password as i Cannot update the month calender in the index sheet. It is still showing november 2009 & it is interlinked with all other sheets i Believe.Please update it and forward me on my
From India, Hyderabad
Dear Sir
Hats of to you for breaking the excel macros
I am unable to include the members in the the payslip format
It is indicating error in the Employee Name ,Designation everywhere
Please find the attachment in Payslip at Employee No 020
I have used the formulas then too it is showing error
Please suggest me how to correct it
And even the Basic Salary calculations are wrong I believe
The Net Salary for Gross Salary 0f Rs 21000/- I am getting 13950 only as Net Salary
Please Sir Correct and send it to me
Thanking You
D.DHANASHEKAR
From India, Bangalore
Hats of to you for breaking the excel macros
I am unable to include the members in the the payslip format
It is indicating error in the Employee Name ,Designation everywhere
Please find the attachment in Payslip at Employee No 020
I have used the formulas then too it is showing error
Please suggest me how to correct it
And even the Basic Salary calculations are wrong I believe
The Net Salary for Gross Salary 0f Rs 21000/- I am getting 13950 only as Net Salary
Please Sir Correct and send it to me
Thanking You
D.DHANASHEKAR
From India, Bangalore
Dear Sir,
Your job is very much appreciable and that too for sharing the same.
I have gone thro' the attendance sheet and there are "X,A,H,S,PH" to mark. But if a person worked for half day and takes half day leave, how I can mark the same?
Please correct the same or you can inform me how to correct it.
Thanks & regards
MANJUNATH KS
From India, Bangalore
Your job is very much appreciable and that too for sharing the same.
I have gone thro' the attendance sheet and there are "X,A,H,S,PH" to mark. But if a person worked for half day and takes half day leave, how I can mark the same?
Please correct the same or you can inform me how to correct it.
Thanks & regards
MANJUNATH KS
From India, Bangalore
Dear All,
To unprotect any Excel sheet follow the program which is really benificial
to all.
1) just open Excel file which you want to unprotect.
2) press ALT+F11 (micros window will be open)
3) Select any Sheet from left side of the window
4) then pest following program:
Sub PasswordBreaker()
'Breaks worksheet password protection.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
then go to run obtion and press run macros
now your file will be unprotected.
enjoy guyes...
From India, Mumbai
To unprotect any Excel sheet follow the program which is really benificial
to all.
1) just open Excel file which you want to unprotect.
2) press ALT+F11 (micros window will be open)
3) Select any Sheet from left side of the window
4) then pest following program:
Sub PasswordBreaker()
'Breaks worksheet password protection.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
then go to run obtion and press run macros
now your file will be unprotected.
enjoy guyes...
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Attendance Register.xls