authentic jerseys for cheap jersey shirts wholesale basketball jerseys wholesale softball jerseys wholesale mlb jerseys wholesale blank hockey jerseys wholesale wholesale blank football jerseys youth soccer jerseys wholesale blank hockey jerseys wholesale wholesale nfl football jerseys authentic soccer jerseys wholesale wholesale nfl jerseys

 

We accept proposals for custom made spreadsheets

Spreadsheets with automation

All worksheets are automatically linked together so figures only need to be entered once!

We are happy to help you make your software that best fits your needs

Easy and powerful tools to control your money flows. They will help you to stop wasting your money and Start your Savings!

‘Add a module and insert this macros

Sub Protect()
Dim FileName, FileDir, FileSearch As String
FileDir = “C:\My folder here\” ‘Change to suit
FileSearch = “*.xls”
FileName = Dir(FileDir & FileSearch)
Do While FileName <> “”
Workbooks.Open FileName:=FileDir & FileName
‘Workbooks(FileName).Protect Password:=”aa”, Structure:=True, Windows:=False
‘ActiveSheet.Protect Password = “aa”, Structure:=True, Windows:=False
ActiveSheet.Protect “aa”
Workbooks(FileName).Save
Workbooks(FileName).Close
FileName = Dir()
Loop
End Sub

Sub UnProtect()
Dim FileName, FileDir, FileSearch As String
FileDir = “C:\My folder here\” ‘Change to suit
FileSearch = “*.xls”
FileName = Dir(FileDir & FileSearch)
Do While FileName <> “”
Workbooks.Open FileName:=FileDir & FileName
ActiveSheet.UnProtect “aa”
‘Workbooks(FileName).UnProtect Password = “aa”
Workbooks(FileName).Save
Workbooks(FileName).Close
FileName = Dir()
Loop
End Sub

0
Connecting
Please wait...
Send a message

Sorry, we aren't online at the moment. Leave a message.

* Your name
* Email
* Describe your issue
    Login now

    Need more help? Save time by starting your support request online.

    * Your name
    Email
    * Describe your issue
    We're online!
    Feedback

    Help us help you better! Feel free to leave us any additional feedback.

    How do you rate our support?