View Poll Results: Do You Like?
Yes 748 90.56%
No 81 9.81%
Multiple Choice Poll. Voters: 826. You may not vote on this poll

tanya.joseph86
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
rajpatnaik
6

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
Attached Files (Download Requires Membership)
File Type: xls Systematic and Faster Attendance Register Fully Designed With Macro - Hacked.xls (787.5 KB, 2624 views)

sunjoa198
1

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
sunjoa198
1

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
vydyam78
1

dera Joshua, Please provide the user admin Password.so that i can edit the months in INdex sheet
From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls Systematic and Faster Attendance Register Fully Designed With Macro (EDITED).xls (787.5 KB, 697 views)

vydyam78
1

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
Attached Files (Download Requires Membership)
File Type: xls Systematic and Faster Attendance Register Fully Designed With Macro (EDITED).xls (807.0 KB, 773 views)

dhanashekar01
1

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
manjuks.horanadu
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
pkgawade
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
raghavendravijayrao
1

I have attendance register modified to suit my requirement , how do i generate report based on the attendance recorded. Can someone help me . to generate attendance and absence report.
From India, Thane
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.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.